Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Mon, 23 May 2011 @ 22:28:57 GMT

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

Subj:   Re: Multi value compression and presence bits

Thanks for the reply. So I going to ask the problem I am trying to solve. I have field call STATE_CD char(02). The local state has about 1/2 of the values, but there are state from all across the country. I decided to compress all 50 states. I was told this is a bad idea because of the presence bit overhead.

  <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