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