15.00 - Compressing Hash Index Column Values - Teradata Database

Teradata Database SQL Data Definition Language Detailed Topics

prodname
Teradata Database
vrm_release
15.00
category
Programming Reference
featnum
B035-1184-015K

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.