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);