ALL_JOIN_IND_COLUMNS describes the join conditions of bitmap join indexes accessible to the current user. 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.
DBA_JOIN_IND_COLUMNS describes all join conditions in the database.
USER_JOIN_IND_COLUMNS describes the join conditions owned by the current user. This view does not display the INDEX_OWNER column.
| Column | Datatype | NULL | Description |
|---|---|---|---|
INDEX_OWNER |
VARCHAR2(30) |
NOT NULL |
Owner of the bitmap join index |
INDEX_NAME |
VARCHAR2(30) |
NOT NULL |
Name of the bitmap join index |
INNER_TABLE_OWNER |
VARCHAR2(30) |
NOT NULL |
Owner of the fact table |
INNER_TABLE_NAME |
VARCHAR2(30) |
NOT NULL |
Name of the fact table |
INNER_TABLE_COLUMN |
VARCHAR2(30) |
NOT NULL |
Name of the fact table join column |
OUTER_TABLE_OWNER |
VARCHAR2(30) |
NOT NULL |
Owner of the dimension table |
OUTER_TABLE_NAME |
VARCHAR2(30) |
NOT NULL |
Name of the dimension table |
OUTER_TABLE_COLUMN |
VARCHAR2(30) |
NOT NULL |
Name of the dimension table join column |