Hash Indexes - Teradata Database

Hash Indexes

Hash indexes are similar to single-table join indexes, though their SQL definition syntax is more similar to that of secondary indexes.

The MultiLoad and FastLoad utilities do not support target tables with hash indexes. The workaround for this is to FastLoad new rows into an empty table and then use either a INSERT … SELECT or MERGE request to populate the indexed table (see SQL Data Manipulation Language for details).

Teradata recommends using single‑table join indexes rather than hash indexes.

For additional information, see “Hash Indexes” on page 166 and Chapter 10: “Join and Hash Indexes.”

Related Topics

For more information on...	See in this book...	See in SQL Data Definition Language...
Primary indexes	Chapter 8: “Primary Index, Primary AMP Index, and NoPI Objects.”	CREATE TABLE
Secondary indexes	Chapter 9: “Secondary Indexes.”	CREATE INDEX CREATE TABLE
Join and hash indexes	Chapter 10: “Join and Hash Indexes.”	CREATE JOIN INDEX CREATE HASH INDEX