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: ...

Get V14 Certification: Teradata Basics now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.