16.20 - ORDER BY - Teradata Database - Teradata Vantage NewSQL Engine

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.

VALUES

ORDER BY VALUES was used to create the index.

VALUES can order a single numeric column of four bytes or less.

HASH

ORDER BY HASH was used to create the index.

HASH hash-orders a single column instead of hash-ordering all columns (the default).

column_name_2

Name of a column on which the index was ordered.