15.00 - Hash Indexes - Teradata Database

Teradata Database Design

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

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 217 and Chapter 11: “Join and Hash Indexes.”

Related Topics

 

For more information on...

See in this book...

See in SQL Data Definition Language...

Primary indexes

Chapter 9: “Primary Indexes and NoPI Objects.”

CREATE TABLE

Secondary indexes

Chapter 10: “Secondary Indexes.”

  • CREATE INDEX
  • CREATE TABLE
  • Join and hash indexes

    Chapter 11: “Join and Hash Indexes.”

  • CREATE JOIN INDEX
  • CREATE HASH INDEX