Archives of the TeradataForum
Message Posted: Wed, 06 Mar 2002 @ 14:20:48 GMT
| 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.