Example: Creating a Hash Index According to Order Date by Order ID - Teradata Vantage - Analytics Database

The following hash index is distributed on o_orderkey (the primary index for the base table Orders) and stored in value order on o_orderkey (the order key for the base table orders):

CREATE HASH INDEX ord_hidx_3 (o_orderdate) ON orders
ORDER BY VALUES;

Note that the ordering column of the base table complies with the rules that it be limited to a single numeric column four or fewer bytes in length.

This creates an index that is equivalent in structure to the following join index:

CREATE JOIN INDEX ord_jidx_3 AS
 SELECT o_orderkey, o_orderdate, orders.ROWID 
 FROM orders
 ORDER BY o_orderkey
PRIMARY INDEX (o_orderkey);