First page Back Continue Last page Graphics

Data Dictionary

*_INDEXES
- New Column
  - JOIN_INDEX
*_IND_COLUMNS
- TABLE_NAME column indicates the dimension table used
*_JOIN_IND_COLUMNS
- New view in Oracle9i

Notes:

To support the new bitmap join index feature of Oracle9i, Oracle has changed some existing data dictionary views and has added a new view.
The JOIN_INDEX column has been added to the *_INDEXES view. It has a value of TRUE if the corresponding index is a bitmap join index otherwise it has a value of FALSE.
With the *_IND_COLUMNS view, the value contained in the TABLE_NAME column will be the dimension table name and not the table name that was used in the ON clause of the CREATE BITMAP INDEX statement.
*_JOIN_IND_COLUMNS is a new view in Oracle9i. It contains information regarding the join conditions of any bitmap join indexes that have been created.