Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Tue, 21 Mar 2001 @ 04:49:32 GMT


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


Subj:   Re: Placement of VARCHAR and COMPRESSed Columns In A Row
 
From:   Michael Larkins

Hi David:

When creating tables in Teradata, the defined order of the columns is not a concern. The RDBMS will automatically put the VARCHAR columns at the end of the disk record regardless of their defined location within the CREATE TABLE.

Although they physically appear last on disk, the SELECT * will return them in the sequence of the CREATE TABLE.


Hope this helps,

Mike



     
  <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: 27 Dec 2016