Chapter 16 - Compression
“If you aren’t compressing your Teradata tables using Multi-Value Compression (MVC), you are simply leaving money on the table.”
- Tera-Tom Coffing
User Defined Compression Techniques
All of the above techniques can also be used for Columnar (Column Partitioned Tables).
Lossy and Lossless Compression
The following are lossless compression techniques:
1. Row Compression (Only used in Join Indexes or Hash Indexes)
2. Multi-Value Compression (MVC)
3. Block-Level Compression (BLC)
4. Columnar Auto Compression
Things to Remember: ...