Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Wed, 06 Mar 2002 @ 14:20:48 GMT

  <Prev Next>   <<First <Prev Next> Last>>  

Subj:   Re: Another ALTER TABLE question
From:   Kumaran Anantaraman

Teradata does recognize an order of columns, at least internally. And this order is important for performance.

For example, under the topic compress, the manual says

When new columns are being added, the first column defined is assigned the lowest column id. Column ids may be important if you specify any column for COMPRESS. As a general rule, the compressed column that will have the highest rate of access and the lowest rate of compressible values should be defined before other compressed columns.

  <Prev Next>   <<First <Prev Next> Last>>  
  Top Home Privacy Feedback  
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 28 Jun 2020