17.10 - Row Compression - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - Database Design

Advanced SQL Engine
Teradata Database
Release Number
Release Date
July 2021
Content Type
User Guide
Publication ID
English (United States)

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 the information about CREATE JOIN INDEX in Teradata Vantage™ - SQL Data Definition Language Detailed Topics, B035-1184.

You can use row compression for hash and 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 Teradata Vantage™ - SQL Data Definition Language Syntax and Examples, B035-1144). The row compression of hash indexes is automatic and requires no special syntax.