Index for which statistics are to be collected.
- 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.
-
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.
- 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.