15.10 - INDEX - 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

Index for which statistics are to be collected.

index_name
The name of the named index for which statistics are to be collected. Note that you specify column names with a named index only when it is defined with an ORDER BY clause.
UNIQUE
The index for which statistics are to be collected is a unique index. This option is not supported for geospatial indexes, because a geospatial index must be a NUSI.
database_name
user_name
The containing database or user for index_name if something other than the current database or user.
ALL
The ALL option was used to create the index. You cannot use this option to collect statistics on a geospatial NUSI.
(column_name_1)
The names of one or more columns on which the index exists and for which statistics are to be collected.
You cannot collect statistics on columns with a data type of Period, JSON, XML, BLOB, CLOB, or any UDT other than Geospatial.
However, you can collect statistics on the BEGIN and END expressions for a Period type column.
A geospatial NUSI column cannot be specified with other columns.
Statistics can be collected on extracted portions of the JSON type. See Teradata JSON, B035-1150.
ORDER BY
An ORDER BY clause was used to create the index.
ORDER BY orders the index by the contents of a single column.
You cannot use this option to collect statistics on a geospatial NUSI.
VALUES
The ORDER BY VALUES option was used to create the index.
VALUES can order a single numeric column of four bytes or less. VALUES is the default.
You cannot use this option to collect statistics on a geospatial NUSI.
HASH
The ORDER BY HASH option was used to create the index.
HASH hash-orders a single column instead of hash-ordering all columns (the default).
You cannot use this option to collect statistics on a geospatial NUSI.
(column_name_2)
The name of the column on which the index is ordered.
You cannot collect statistics on columns with a data type of Period, JSON, XML, BLOB, CLOB, or any UDT other than Geospatial.
However, you can collect statistics on the BEGIN and END expressions for a Period type column.
Statistics can be collected on extracted portions of the JSON type. See Teradata JSON, B035-1150.