Skip Headers

Oracle® Database Reference
10g Release 1 (10.1)

Part Number B10755-01
Go to Documentation Home
Go to Book List
Book List
Go to Table of Contents
Go to Index
Go to Master Index
Master Index
Go to Feedback page

Go to previous page
Go to next page
View PDF


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
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