15.00 - Compression of Hash Indexes at the Block Level - Teradata Database

Teradata Database Design

prodname
Teradata Database
vrm_release
15.00
category
User Guide
featnum
B035-1094-015K

Compression of Hash Indexes at the Block Level

Because hash indexes are primary tables, they can be compressed at the block level. See “Data Block” on page 248, “Reserved Query Bands for Managing the Block-Level Compression and Storage Temperature of Newly Loaded Data” on page 694, and “Compression Types Supported by Teradata Database” on page 695 for more information about data block compression.

Further Information

Consult SQL Data Definition Language for more detailed information on creating and using hash indexes to enhance the performance of your database applications.