15.00 - Restrictions on Join Index ORDER BY Clauses - Teradata Database

Teradata Database Design

prodname
Teradata Database
vrm_release
15.00
category
User Guide
featnum
B035-1094-015K

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