ALL_JOIN_IND_COLUMNS

ALL_JOIN_IND_COLUMNS describes the join conditions of bitmap join indexes to which you have access. Bitmap join indexes are indexes built on a child table with an index key containing columns from associated parent tables, where all of the tables are connected through join conditions. There is one row for each join condition.

Related Views

• DBA_JOIN_IND_COLUMNS describes all join conditions exiting in the database.
• USER_JOIN_IND_COLUMNS describes join conditions owned by the current user. This view does not display the INDEX_OWNER column.

  Column	Datatype	Description
  INDEX_OWNER	VARCHAR2(30)	Bitmap join index owner
  INDEX_NAME	VARCHAR2(30)	Name of bitmap join index
  INNER_TABLE_OWNER	VARCHAR2(30)	Fact table owner
  INNER_TABLE_NAME	VARCHAR2(30)	Name of the fact table
  OUTER_TABLE_OWNER	VARCHAR2(30)	Dimension table owner
  OUTER_TABLE_NAME	VARCHAR2(30)	Name of the dimension table
  COL_NAME_INNER	VARCHAR2(4000)	Name of the fact table join column
  COL_NAME_OUTER	VARCHAR2(4000)	Name of the dimension table join column