Archives of the TeradataForum
Message Posted: Tue, 20 Mar 2001 @ 20:31:26 GMT
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.
|Copyright 2016 - All Rights Reserved|
|Last Modified: 23 Jun 2019|