Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Thu, 12 Sep 2002 @ 22:19:04 GMT


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


Subj:   Re: Verifying Column Compression
 
From:   Morris, Mark

The nullability presence bit is only present for nullable columns and is there whether they are compressed or not.

In Tony's case, you are right, the 15 non-null columns being compressed will cause 15 additional presence bits, and the odds are that this works out to 2 additional presence bytes. (Unless there just happened to be 7 bits available in the existing lastmost presence byte).

So the question is: are there 27 billion rows in the table?

If not, just on a lark, did you check that there is not a typo on the default string or the compress string so that they don't match?.

Mark



     
  <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