Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Tue, 13 Aug 2013 @ 13:58:31 GMT


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


Subj:   Re: Space occupied in varchar columns
 
From:   Lavai Akos

Hi!

You did not consider the RowID and other overheads.

If you do compress testing you can not isolate one column, since compression packs the bits, therefore the optimum can be found on record level.

This implies, that you should try some compression tool, instead of manual experiment, the algorithm is far more complex, and too much manual work...

You can find downloadable solutions on the net.

In addition if you are on V13.10 or above you can compress VARCHAR either.


Regrads,

Akos



     
  <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: 23 Jun 2019