15.10 - ORDER BY - Teradata Database

Teradata Database SQL Data Definition Language Syntax and Examples

prodname
Teradata Database
vrm_release
15.10
created_date
December 2015
category
Programming Reference
featnum
B035-1144-151K

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.