Home Page for the TeradataForum
 
https:

Archives of the TeradataForum

Message Posted: Tue, 13 Aug 2013 @ 11:45:50 GMT


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


Subj:   Re: Space occupied in varchar columns
 
From:   Gregg, William

Hi Anonymous -- Teradata reserves space in each block for housekeeping needs. In this case it appears that it uses about 80 bytes. In larger blocks, my understanding is that more space is reserved, but it has been years since I read the details. Check the manuals for exact numbers.

I suggest that U test with a larger blocksize. Try 128k or perhaps 64k. I suspect that U will find more useful results that way.


Rgrds,

Bill Gregg



     
  <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: 24 Jul 2020