16.20 - Join Index 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_name
Name of the join index for which information is desired.
database_name
user_name
Name of the containing database or user for join_index_name if something other than the current database or user.

Example: HELP JOIN INDEX on a Join Index

The following example shows the output of a HELP JOIN INDEX request performed on the join index named ord_cust_idx.

     HELP JOIN INDEX ord_cust_idx;
     Column Name     Type   Comment
     --------------  -----  ------------------
     c_custkey       I      ?
     c_name          CF     ?
     o_status        CF     ?
     o_date          DA     ?
     o_comment       CV     ?