Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Thu, 10 Jun 2004 @ 15:55:30 GMT


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


Subj:   Re: Null or compress zeros
 
From:   Dieter Noeth

Nazy Gholizadeh wrote:

  Which is smaller, Null or 0.00 compressed (when defined as Decimal(15,2)?  


col dec(15,0):

     NULL -> 8 bytes
     0.00 -> 8 bytes

col dec(15,0) compress:

     NULL -> 1 bit
     0.00 -> 8 bytes

col dec(15,0) compress 0:

     NULL -> 2 bits
     0.00 -> 2 bits

col dec(15,0) not null compress 0:

     NULL -> impossible
     0.00 -> 1 bit

Dieter



     
  <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: 27 Dec 2016