HELP JOIN INDEX Example | Teradata Vantage - 17.05 - Example: HELP JOIN INDEX on a Join Index - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - SQL Data Definition Language Syntax and Examples

Advanced SQL Engine
Teradata Database
Release Number
Release Date
January 2021
Content Type
Programming Reference
Publication ID
English (United States)

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     ?