HELP INDEX Syntax Elements - 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™
TEMPORARY
Requested indexes are defined on a materialized global temporary table.
 This keyword is valid only for global temporary tables.
database_name_1
user_name_1
Containing database or user for table_name if something other than the current database or user.
table_name
Table on which a report of all primary and secondary indexes is desired.
database_name_2
user_name_2
Containing database or user for join_index_name, hash_index_name, or view_name if something other than the current database or user.
join_index_name
Join index on which all primary and secondary indexes are reported.
hash_index_name
Hash index on which a report of all primary indexes is desired.
view_name

Name of a single-table view for which index information is required.

You can only request HELP INDEX reports for single-table views.

column_name
Column in a column list for which an index or index list is desired. Use this syntax to exclude primary, secondary, join, and hash indexes defined on columns for which you are not interested.