Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Mon, 23 May 2011 @ 19:49:20 GMT


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


Subj:   Re: Multi value compression and presence bits
 
From:   DWellman

Hi David,

I don't think so.

As far as I'm aware, there is only one byte reserved for presence bits by default. This seems to be confirmed by reading Chap 15 of the Database Design manual (TD 13.10). This says:

- there is 1 byte for "first presence bits array"

- there are 0-n bytes for "additional presence bits array"


I can't explicitly find it mentioned, but it always used to be that from this first "presence bits array" you only had 7 bits available. That may now have changed because there is a separate "flag byte" listed.

Also, you're correct that 255 values can be 'indexed' within 2 bytes, but remember that you can compress multiple columns within a table definition and each column that you compress 255 values for will require 8 presence bits. So if you compress 6 columns on 255 values (each) you will require 48 bits.

Does that help ?


Cheers,

Dave

Ward Analytics Ltd - Information in motion (www.ward-analytics.com)



     
  <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