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:
You cannot do the following things with hash indexes:
For example, if ordCustHdx is a hash index, then the following query is not legal:
SELECT o_status, o_date, o_comment