  |  
  |  
 
Archives of the TeradataForum 
 
 
Message Posted: Thu, 24 May 2012 @ 12:48:56 GMT 
 
  
 
 
 
 
  
|  Subj:  |   |  Re: Space occupied by blanks  |   
|     |   
|  From:  |   |  Newell, Ray  |   
  
 
 
  
It depends of you have presence bits available.  If you do not have to acquire another presence byte, then compressing a byte, especially on a
large table with say hundreds of rows, could save a significant amount of space.  A lot of times trading a bit for a byte on vary large tables can
be a good tradeoff.  You can look at the tables current nullable and compressible columns and determine if you have available bits within the
current presence bytes. 
 
 
 
 
   
 
 |   |