The following hash index is distributed on o_orderkey (the primary index for the base table Orders) and stored in value order on o_orderdate:
CREATE HASH INDEX ord_hidx_5 (o_orderdate) ON orders ORDER BY (o_orderdate);
Equivalently, you could specify ORDER BY VALUES instead of ORDER BY.
This creates an index that is equivalent in structure to the following join index:
CREATE JOIN INDEX ord_jidx_5 AS SELECT (o_orderdate), (o_orderkey, orders.ROWID) FROM orders ORDER BY o_orderdate PRIMARY INDEX (o_orderkey);