Oracle Tips by Burleson

dba_join_ind_columns

DBA_JOIN_IND_COLUMNS
Join Index columns comprising the join conditions
------------------------------------------------------------------------------------
INDEX_OWNER 	VARCHAR2 	Index owner
INDEX_NAME 	VARCHAR2 	Index name
INNER_TABLE_OWNER 	VARCHAR2 	Table owner of inner table (table closer to the fact table)
INNER_TABLE_NAME 	VARCHAR2 	Table name of inner table (table closer to the fact table)
INNER_TABLE_COLUMN 	VARCHAR2 	Column name of inner table (table closer to the fact table)
OUTER_TABLE_OWNER 	VARCHAR2 	Table owner of outer table (table closer to the fact table)
OUTER_TABLE_NAME 	VARCHAR2 	Table name of outer table (table closer to the fact table)
OUTER_TABLE_COLUMN 	VARCHAR2 	Column name of outer table (table closer to the fact table)