15.10 - ORDER BY - Teradata Database

Teradata Database SQL Data Definition Language Syntax and Examples

Product
Teradata Database
Release Number
15.10
Published
December 2015
Content Type
Programming Reference
Publication ID
B035-1144-151K
Language
English (United States)
Last Update
2018-06-05

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.