Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Tue, 02 Mar 2004 @ 20:17:31 GMT


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


Subj:   Re: Calculating the Efficiency Of compression
 
From:   Victor Sokovin

On Tue, 2 Mar 2004 10:48:32 -0800, Rick Davis wrote:

  What is this "table header bytes used by compressed column " , where can I get this info ? , is this same as column length  


  2) row_header_space = table_cardinality * (presence_octets -1)  


  how to calculate "presence octets" ? where can I get this info ?  



These concepts are described in "Database Design", doc ID=B035-1094-083A (November 2003). You should find examples there as well.


Regards,

Victor



     
  <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