Archives of the TeradataForum
Message Posted: Tue, 27 Aug 2002 @ 19:58:27 GMT
| 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.
Dave
Ward Analytics Ltd: Information in motion (www.ward-analytics.com)
| 
