Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Thu, 02 Mar 2006 @ 11:15:01 GMT


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


Subj:   Re: SQL for record length calculation
 
From:   Victor Sokovin

  Is this a correct SQL statement to calculate record length?  


I guess this depends on the purpose of the calculation.

The formula above will give you an idea of the *maximum* number of bytes which may be allocated for the data in a row. If, for example, you have VARCHAR(N) columns then all of them must be filled up to their respective Ns to attain that maximum. If you use multibyte encodings you should be aware of the difference between the number of characters and the number of bytes allocated.

All of this is only data related; the formula does not take into account the space Teradata might need to allocate for internal technical purposes.


Regards,

Victor



     
  <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