Row Compression - Teradata VantageCloud Lake

Lake - Database Reference

Deployment
VantageCloud
Edition
Lake
Product
Teradata VantageCloud Lake
Release Number
Published
February 2025
ft:locale
en-US
ft:lastEdition
2025-11-21
dita:mapPath
ohi1683672393549.ditamap
dita:ditavalPath
pny1626732985837.ditaval
dita:id
ohi1683672393549

Row compression is a form of logical data compression in which Vantage stores a repeating column value set only once, while any non-repeating column values that belong to that set are stored as logical segmental extensions of the base repeating set. Row compression is a lossless method.

Like multivalue compression, there is no decompression necessary to access row compressed data values. For an explanation of row compression, see Row Compression of Join Indexes .

You can use row compression for join indexes that are defined on row-level security-protected columns.

You control the row compression of join indexes with the syntax you use when you create an index (see CREATE JOIN INDEX ).