Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Tue, 20 Mar 2001 @ 23:15:23 GMT

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

Subj:   Re: Placement of VARCHAR and COMPRESSed Columns In A Row
From:   Fred Pluebell

Take a look at the "Teradata RDBMS Database Design" manual. In the version I have (B035-1094-060A) the information you want is in Chapter 12 - Database-Level Considerations.

David Carlson wrote:

  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.  

Teradata automatically adjusts the physical order of different classes of columns within the row: all fixed length columns in the row, followed by uncompressed data from compressible columns, followed by variable length columns.

  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.  

For the first few (e.g. "five or less") compressed columns, the performance impact is negligible even if there's not much space savings. But the more columns you compress, the more important it is to weigh the tradeoffs between space and processing time, and to consider other factors such as the relative order of 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