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.