15.00 - Compressing Hash Index Column Values - Teradata Database

Teradata Database SQL Data Definition Language Detailed Topics

Teradata Database
Release Number
Content Type
Programming Reference
Publication ID
English (United States)

Compressing Hash Index Column Values

Unlike what happens by default when you create a join index (see “Compression of Join Index Column Values” on page 379), Teradata Database does not automatically transfer column multi-value compression defined on the base table to the hash index definition. You cannot compress hash index column values.