The following hash index is distributed on its primary index o_orderdate and stored in value order on o_orderkey (the primary index for the base table orders ):
CREATE HASH INDEX ord_hidx_6 (o_orderdate) ON orders BY (o_orderdate) 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_6 AS SELECT o_orderkey, o_orderdate, orders.ROWID FROM orders ORDER BY o_orderkey PRIMARY INDEX (o_orderdate);