Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Thu, 17 Apr 2008 @ 13:41:03 GMT


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


Subj:   Multi value compression on NULLs
 
From:   Anomy Anom

<-- Anonymously Posted: Thu, 17 Apr 2008 17:57 -->

Hi,

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?


Regards



     
  <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: 27 Dec 2016