Archives of the TeradataForum
Message Posted: Mon, 28 May 2001 @ 08:23:08 GMT
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 .
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|