Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Mon, 28 May 2001 @ 08:23:08 GMT

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

Subj:   Re: Compress
From:   Howard Bradley

Petr ,

We recently applied Compression across a large number of our Production tables which are populated using Multiload or BTEQ Inserts .

We compressed any columns within the table which we felt were candidates for compression (one table has over 40 columns with compression applied) . This has greatly reduced the amount of PERMPACE taken up by our production environment (1 table reduced from 16 GIG used to 8 GIG) and we have not experienced any adverse affects in performance , in fact , although its difficult to measure , we feel we have had performance gains when querying some of the tables . I think this is due to the number of rows being retrieved in each block read but I will leave that sort of explanation to the techies on the list (cue Dave Wellman) .

We now consider compression on every new table introduced into the Data Warehouse as part of our standard implementation process .

Howard .

  <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