Archives of the TeradataForum

Message Posted: Wed, 30 May 2001 @ 19:18:07 GMT

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

Cornelius,

While it would be ideal to do the analysis of the data beforehand in order to do the compression, that is not necessary with Teradata. One can ususally do the data analysis for compression as part of the query performance tuning AFTER most of the data has been loaded.

If there is a need for a more generalized and less efficient compression option, one can just add the compression option to all the columns in a table upon initial definition of the table. I would think that the efficiency of compression between a fine vs coarse level of compression would often be significant. With the improvement in CPU speeds, the benefit of compression would be higher with finer and finer levels of compression.

Yen Tsai

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