Archives of the TeradataForum
Message Posted: Tue, 20 Mar 2001 @ 23:15:23 GMT
| 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.