Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Wed, 06 Jun 2007 @ 18:12:22 GMT


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


Subj:   Re: Null Value
 
From:   DWellman

Hi,

Yes it does depend on the type of field and also whether or not the column is compressed.

Each NULLable column requires one "presence bit" which is stored in the row header.

If a column contains NULL and is compressed (remember that if you specify compression on any value in Teradata the NULLs are also compressed) then the only physical space required is for the presence bit.

- if you've got compression involved remember that there are also presence bits required for compression.

If a column contains NULL and is NOT compressed, then the phsyical space required is the space that would normally be used by a non-NULL value - e.g. a DATE column will require 4 bytes, a CHAR(10) will require 10 bytes. If the column is a VARCHAR and contains NULL then (I think) it requires 0 bytes, but it may be 2 bytes for the variable length indicator, I'm not sure.


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