Archives of the TeradataForum
Message Posted: Tue, 27 Aug 2002 @ 19:58:27 GMT
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)
|Copyright 2016 - All Rights Reserved
|Last Modified: 15 Jun 2023