Skip Headers
Oracle® Database Reference
11g Release 2 (11.2)

E40402-12
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Index
Index
Go to Master Index
Master Index
Go to Feedback page
Contact Us

Go to previous page
Previous
Go to next page
Next
PDF · Mobi · ePub

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

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