Home Page for the TeradataForum

Archives of the TeradataForum

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

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

Subj:   Re: Compress
From:   Yen Tsai


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>>  
  Top Home Privacy Feedback  
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 28 Jun 2020