order_clause - Advanced SQL Engine - Teradata Database

SQL Data Definition Language Syntax and Examples

Product
Advanced SQL Engine
Teradata Database
Release Number
17.05
Published
January 2021
Language
English (United States)
Last Update
2021-01-22
dita:mapPath
ncd1596241368722.ditamap
dita:ditavalPath
hoy1596145193032.ditaval
dita:id
B035-1144
lifecycle
previous
Product Category
Teradata Vantage™

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.