Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Wed, 03 Oct 2012 @ 16:55:07 GMT


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


Subj:   Re: Compression Process on Teradata 13.10
 
From:   frank.c.martinez

Well, we use a tool to do the compression analysis, a very good one (but they don't like us mentioning tool names here), so we've been using Multi-value compression for a while. We've just done an analysis with that same tool to add compression to VARCHAR, which is new with v13.10, and between that and the tool detecting that we could change some CHAR columns to VARCHAR (retaining the compression), we've estimated that we can save 3 terabytes out of one 7 terabyte table. Cool beans.


iv



     
  <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