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;
Result:
Column Name Type Comment -------------- ----- ------------------ c_custkey I ? c_name CF ? o_status CF ? o_date DA ? o_comment CV ?