 |
 |
Archives of the TeradataForum
Message Posted: Tue, 29 May 2001 @ 14:11:03 GMT
| Subj: | | Teradata Compress |
| |
| From: | | Al Czajkowski |
We consider all columns as candidates for compress and use it regularly. In one database, all non-key columns are compressed - tables
have 80 - 130 columns each. We have documented performance improvements relative to these compressed tables in all areas - 30% in load (we
m-load these), varying in query, 60% in space usage, and 60% in archive. The individual rows in these tables do not get updated.
Electronically
Allen J. Czajkowski
DBA Supervisor, Data Warehousing
Ford Motor Credit Company
| |
