Similarities of Hash Indexes to Base Tables - Teradata Database

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.