Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Tue, 20 Mar 2001 @ 20:31:26 GMT


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


Subj:   Placement of VARCHAR and COMPRESSed Columns In A Row
 
From:   David Carlson

Has anyone run across recommendations of where to place VARCHAR and COMPRESSed columns in a table? Should these columns be placed at the end of the row or does it really matter? I know from work on other platforms that this could potentially be an performance issue but cannot find any documentation on this.

Also noticed in the SQL Reference Manual that NCR recommends applying compression to 'five columns or less' to minimize the impact to access time. Does anyone know if this is still the recommendation? Seems really low considering the increases in performance over the years. Any thoughts.


Regards,

Dave Carlson



     
  <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