17.00 - INDEX - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - SQL Data Definition Language Syntax and Examples

Product
Advanced SQL Engine
Teradata Database
Release Number
17.00
Release Date
September 2020
Content Type
Programming Reference
Publication ID
B035-1144-170K
Language
English (United States)

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 Vantage™ - JSON Data Type, 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 Vantage™ - JSON Data Type, B035-1150.