15.00 - Similarities of Hash Indexes to Base Tables - Teradata Database

Teradata Database Design

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

Similarities of Hash Indexes to Base Tables

In many respects, a hash index is identical to a base table.

For example, you perform any of the following statements against a hash index:

  • COLLECT STATISTICS (Optimizer Form)
  • DROP HASH INDEX
  • DROP STATISTICS (Optimizer Form)
  • HELP HASH INDEX
  • SHOW HASH INDEX
  • You cannot do the following things with hash indexes:

  • Query or update hash index rows.
  • For example, if ordCustHdx is a hash index, then the following query is not legal:

         SELECT o_status, o_date, o_comment 
         FROM ordCustHdx;
  • Store and maintain arbitrary query results.
  • Create secondary indexes on its columns.
  • Create them on either a NoPI or column‑partitioned table.