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 .