Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Tue, 27 Aug 2002 @ 19:58:27 GMT

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

Subj:   Re: Question on compression
From:   David Wellman

Typically the ones to choose for compression are those where you will get a lot of disk space savings by using the COMPRESS feature.

Under current release of Teradata this means a column which has a significant number of rows with the same value (and possibly also contains lots of NULLs). With Teradata v2r5 you'll be able to specify multiple COMPRESS values per column (I think up to 5).

Don't forget that you can't compress PI columns or VARCHARs.


Ward Analytics Ltd: Information in motion (www.ward-analytics.com)

  <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: 15 Jun 2023