15.00 - Row Compression - Teradata Database

Teradata Database Design

Teradata Database
User Guide

Row Compression

Row compression is a form of logical data compression in which Teradata Database 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 multi-value compression, there is no decompression necessary to access row compressed data values. For an explanation of row compression, see “CREATE JOIN INDEX” in SQL Data Definition Language Detailed Topics.

Note: 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 “CREATE JOIN INDEX” in SQL Data Definition Language). The row compression of hash indexes is automatic and requires no special syntax.