15.10 - column_name_3 - Teradata Database

Teradata Database SQL Data Definition Language Syntax and Examples

Teradata Database
Release Number
December 2015
Content Type
Programming Reference
Publication ID
English (United States)

Column set on which the index is to be ordered.

If you specify ORDER BY VALUES, then you can specify only one column for column_name_3.

The specified column set must be a subset of column_name_1.

You cannot specify the system-derived columns PARTITION or PARTITION#L n in the column name list. However, you can specify a user-defined column named partition or partition#L n, where n ranges from 1 through 62.

You cannot specify the same column twice in the column_name_3 list.

You cannot compress column values for a hash index.

You cannot order an index by a Period, BLOB, CLOB, LOB UDT, Geospatial, VARIANT_TYPE, or ARRAY/VARRAY column.