15.00 - Compressing Hash Index Column Values - Teradata Database

Teradata Database SQL Data Definition Language Detailed Topics

Product
Teradata Database
Release Number
15.00
Content Type
Programming Reference
Publication ID
B035-1184-015K
Language
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.