Row Compression - Analytics Database - Teradata Vantage

SQL Data Definition Language Syntax and Examples

Deployment
VantageCloud
VantageCore
Edition
Enterprise
IntelliFlex
VMware
Product
Analytics Database
Teradata Vantage
Release Number
17.20
Published
June 2022
Language
English (United States)
Last Update
2024-10-04
dita:mapPath
jco1628111346878.ditamap
dita:ditavalPath
qkf1628213546010.ditaval
dita:id
mdr1472255012272
lifecycle
latest
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 Teradata Vantage™ - SQL Data Definition Language Detailed Topics, B035-1184.

You cannot specify row compression for a partitioned join index.