Row Compression - Advanced SQL Engine - Teradata Database

SQL Data Definition Language Syntax and Examples

Product
Advanced SQL Engine
Teradata Database
Release Number
17.00
Published
September 2020
Language
English (United States)
Last Update
2021-01-23
dita:mapPath
wgr1555383704548.ditamap
dita:ditavalPath
lze1555437562152.ditaval
dita:id
B035-1144
lifecycle
previous
Product Category
Teradata Vantage™

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 “Row Compression of Join Indexes” in Teradata Vantage™ - SQL Data Definition Language Detailed Topics , B035-1184 .

You cannot specify row compression for a partitioned join index.