15.10 - Join Index Name - Teradata Database

Teradata Database SQL Data Definition Language Syntax and Examples

Product
Teradata Database
Release Number
15.10
Published
December 2015
Content Type
Programming Reference
Publication ID
B035-1144-151K
Language
English (United States)
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     ?