The following restrictions apply to ORDER BY clauses specified in a join index definition:
- Sort order is restricted to ASC.
DESC is not valid.
- Aggregate columns and expressions are not permitted as a column_name or column_position specification.
- Supported data types for column_name are restricted to the following:
- DATE
- BYTEINT
- DECIMAL (only for columns of four or fewer bytes)
- INTEGER
- SMALLINT