When creating tables in Teradata is there an advantage to placing the column(s) that will be used for the Primary Index at the top of the column list?
Also, when several columns in a table are defined as varchar, is there a performance gain when these columns are grouped together at the end of the column list? In other systems this minimizes the amount of data that must be shifted when a value in one of the varchar columns is updated.
The physical layout of the Teradata record (on the disk) is different than your specification. There is nothing you can do, significant to your basic table specification, that can alter the internal layout. The Database Design manual (under Row Structure) explains this.