ORDER BY was used to create the index.
ORDER BY orders the index by the contents of a single column. If you specify ORDER BY but not VALUES or HASH, then VALUES is assumed.
- ORDER BY VALUES was used to create the index.
- VALUES can order a single numeric column of four bytes or less.
- ORDER BY HASH was used to create the index.
- HASH hash-orders a single column instead of hash-ordering all columns (the default).
- Name of a column on which the index was ordered.