15.10 - Join Index Name - Teradata Database

Teradata Database SQL Data Definition Language Syntax and Examples

prodname
Teradata Database
vrm_release
15.10
created_date
December 2015
category
Programming Reference
featnum
B035-1144-151K
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     ?