2.197 ALL_JOIN_IND_COLUMNS
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.
Related Views
-
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 theINDEX_OWNER
column.
Column | Datatype | NULL | Description |
---|---|---|---|
|
|
|
Owner of the bitmap join index |
|
|
|
Name of the bitmap join index |
|
|
|
Owner of the fact table |
|
|
|
Name of the fact table |
|
|
|
Name of the fact table join column |
|
|
|
Owner of the dimension table |
|
|
|
Name of the dimension table |
|
|
|
Name of the dimension table join column |
See Also: