Archives of the TeradataForum
Message Posted: Mon, 28 May 2001 @ 08:23:08 GMT
| 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 .
| 
