15.00 - Multi-Value Compression Guideline - Teradata Database

Teradata Database Design

prodname
Teradata Database
vrm_release
15.00
category
User Guide
featnum
B035-1094-015K

Multi-Value Compression Guideline

Compress column values only when compression does not have the net effect of reducing storage capacity. For information about how to make this determination, see “Calculating the Efficiency of Multi-Value Compression” on page 725.

Multi-value compression produces shorter rows, which in turn generally produce more high‑performing applications.

Note that column multi-value compression, once defined for base table columns, is inherited by join indexes defined on those value‑compressed columns as well retained as a property of spool files containing data from the table as well, so compression is not just a property of data stored on disk.