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 Join Privacy Feedback  
 
 
Copyright for the TeradataForum (TDATA-L), Manta BlueSky 
Last Modified: 30 Jun 2008