Oracle9i Database Reference Release 1 (9.0.1) Part Number A90190-02 |
|
Static Data Dictionary Views, 41 of 521
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.
DBA_JOIN_IND_COLUMNS
describes all join conditions exiting in the database.
USER_JOIN_IND_COLUMNS
describes join conditions owned by the current user. This view does not display the INDEX_OWNER
column.
|
![]() Copyright © 1996-2001, Oracle Corporation. All Rights Reserved. |
|