17.10 - order_clause - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - SQL Data Definition Language Syntax and Examples

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Release Date
July 2021
Content Type
Programming Reference
Publication ID
B035-1144-171K
Language
English (United States)

Index rows are ordered on each AMP by a single value- or hash-ordered column.

  • If you specify ORDER BY, then you must also specify column_name_2.
  • If you do not specify ORDER BY, Vantage orders rows by the hash value of all the columns in the column_name list.
VALUES
Value-ordering for the ORDER BY column.
If neither VALUES nor HASH is specified, VALUES is used as the default.
HASH
Hash-ordering for the ORDER BY column.
column_name_2
A single column from the column list defined by column_name that specifies the sort order to be used for either HASH or VALUES.
The size of the column is limited to four or fewer bytes. Supported numeric date types for column_name_2 are the following.
  • BYTEINT
  • DATE
  • DECIMAL
  • INTEGER
  • SMALLINT
If you specify ORDER BY without also specifying an explicit 
column_name_2, then the system assumes the first column specified in the column_name list.