15.00 - Tradeoffs Between Multi-Value Compression and Storage Requirements for Compressed Values - Teradata Database

Teradata Database Design

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

Tradeoffs Between Multi-Value Compression and Storage Requirements for Compressed Values

About Multi-Value Compression and Net Capacity for Nulls and Values

While multi‑value compression removes specified values from row storage, those values do not disappear: they must be stored somewhere. This statement applies only to values, not nulls. Null compression is handled by the presence bits in the row header and does not have an impact on the table header.