Restrictions on Join Index ORDER BY Clauses - Teradata Database

Restrictions on Join Index ORDER BY Clauses

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

The DECIMAL type is valid only for columns of four or fewer bytes.

INTEGER

SMALLINT