Archives of the TeradataForum
Message Posted: Thu, 17 Apr 2008 @ 13:41:03 GMT
<-- Anonymously Posted: Thu, 17 Apr 2008 17:57 -->
We are at database version is 06.01.01.
As per TERADATA
COLUMNNAME COMPRESS ('VALUE1'),
The above would compress the values VALUE1 and NULL. But I am not seeing the expected space saving. When I put NULL for compression explicitly as follows, expected space saving is observed.
COLUMNNAME COMPRESS ('VALUE1',NULL).
Has anyone seen this problem? Do we need to explicitly mention NULL in the value list for compression.
/Compression of NULL occurs automatically when compression on any other value on that column is added, /is this right?
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|