Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Mon, 16 Jan 2012 @ 13:48:29 GMT


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


Subj:   Re: Compress Null value
 
From:   Machha Narayan Rao Naidu

Hi,

You will not get any significant changes in terms of Disk space while compressing NULL. If the no. of NULL's are large then you can see a little changes probably.

Below is the chart From Teradata manual on % Compression.

The following table shows example compressibility for fields of 1 and 4 bytes. "Percent compression" is the savings when considering the compressed size in comparison to the uncompressed size.

                    Frequency of
     Field Width    Single Value      Percent
     (Bytes)        (and NULL)        Compression
        1               20%              7%
        1               50%             37%
        1               80%             67%
        4               20%             17%
        4               50%             47%
        4               80%             77%

Note that the compression savings are for a particular column. Overall system savings is dependent on the number of columns that are compressed and the individual savings from each column.


Thanks

Machha



     
  <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