16.20 - Join Index, Hash Index, or View Name - Teradata Database - Teradata Vantage NewSQL Engine

Teradata Vantage™ SQL Data Definition Language Syntax and Examples

Product
Teradata Database
Teradata Vantage NewSQL Engine
Release Number
16.20
Published
March 2019
Language
English (United States)
Last Update
2019-05-24
dita:mapPath
wkf1512081455740.ditamap
dita:ditavalPath
TD_DBS_16_20_Update1.ditaval

Join index, hash index, or view name for which to display information.

database_name
user_name
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.