DBA_JOIN_IND

DBA_JOIN_IND_COLUMNS

Join Index columns comprising the join conditions

Columns
   ___________________________
 
   INDEX_OWNER
      Index owner
   INDEX_NAME
      Index name
   INNER_TABLE_OWNER
      Table owner of inner table (table closer to the fact table)
   INNER_TABLE_NAME
      Table name of inner table (table closer to the fact table)
   INNER_TABLE_COLUMN
      Column name of inner table (table closer to the fact table)
   OUTER_TABLE_OWNER
      Table owner of outer table (table closer to the fact table)
   OUTER_TABLE_NAME
      Table name of outer table (table closer to the fact table)
   OUTER_TABLE_COLUMN
      Column name of outer table (table closer to the fact table)

Related:

Simon Sheppard
SS64.com