17.10 - Row Compression - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - SQL Data Definition Language Syntax and Examples

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Release Date
July 2021
Content Type
Programming Reference
Publication ID
B035-1144-171K
Language
English (United States)

You can compress a set of join index column values that repeat often across rows. This is referred to as row compression. Group the columns with repeating values. Then, group the columns with values that do not repeat frequently. This non-repeating column set is called the fixed column set.

You can configure row compression for a join index. In the join index definition, group the set of repeating columns in parenthesis, then group the fixed set of columns in parenthesis, separating the two groups with a COMMA character.

The join index t3_jindx in Example: Creating Join Indexes With a UDT Column as a Primary or Secondary Index is a simple example of how to create a row-compressed join index.

For a detailed explanation of join index row compression, see Teradata Vantage™ - SQL Data Definition Language Detailed Topics, B035-1184.

You cannot specify row compression for a partitioned join index.