Row Compression - Advanced SQL Engine - Teradata Database

Database Design

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Published
July 2021
Language
English (United States)
Last Update
2021-07-27
dita:mapPath
kko1591750222108.ditamap
dita:ditavalPath
kko1591750222108.ditaval
dita:id
B035-1094
lifecycle
previous
Product Category
Teradata Vantage™

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.