DBA_JOIN_IND_COLUMNS view tips

Oracle Tips by Burleson Consulting

DBA_JOIN_IND_COLUMNS

<< Return to the index

Oracle 11g makes the following comments about the DBA_JOIN_IND_COLUMNS table: "Join Index columns comprising the join conditions"

Related notes on DBA_JOIN_IND_COLUMNS:

Column description of the DBA_JOIN_IND_COLUMNS view:

INDEX_OWNER

Description of DBA_JOIN_IND_COLUMNS.INDEX_OWNER: "Index owner"

INDEX_NAME

Description of DBA_JOIN_IND_COLUMNS.INDEX_NAME: "Index name"

INNER_TABLE_OWNER

Description of DBA_JOIN_IND_COLUMNS.INNER_TABLE_OWNER: "Table owner of inner table (table closer to the fact table)"

INNER_TABLE_NAME

Description of DBA_JOIN_IND_COLUMNS.INNER_TABLE_NAME: "Table name of inner table (table closer to the fact table)"

INNER_TABLE_COLUMN

Description of DBA_JOIN_IND_COLUMNS.INNER_TABLE_COLUMN: "Column name of inner table (table closer to the fact table)"

OUTER_TABLE_OWNER

Description of DBA_JOIN_IND_COLUMNS.OUTER_TABLE_OWNER: "Table owner of outer table (table closer to the fact table)"

OUTER_TABLE_NAME

Description of DBA_JOIN_IND_COLUMNS.OUTER_TABLE_NAME: "Table name of outer table (table closer to the fact table)"

OUTER_TABLE_COLUMN

Description of DBA_JOIN_IND_COLUMNS.OUTER_TABLE_COLUMN: "Column name of outer table (table closer to the fact table)"

DBA_JOIN_IND_COLUMNS View Source

Oracle 11g's data dictionary defines the DBA_JOIN_IND_COLUMNS view using the following source query:

select
ui.name, oi.name,
uti.name, oti.name, ci.name,
uto.name, oto.name, co.name
from
sys.user$ ui, sys.user$ uti, sys.user$ uto,
sys.obj$ oi, sys.obj$ oti, sys.obj$ oto,
sys.col$ ci, sys.col$ co,
sys.jijoin$ ji
where ji.obj# = oi.obj#
and oi.owner# = ui.user#
and ji.tab1obj# = oti.obj#
and oti.owner# = uti.user#
and ci.obj# = oti.obj#
and ji.tab1col# = ci.intcol#
and ji.tab2obj# = oto.obj#
and oto.owner# = uto.user#
and co.obj# = oto.obj#
and ji.tab2col# = co.intcol#

If you like Oracle tuning, see the book "Oracle Tuning: The Definitive Reference", with 950 pages of tuning tips and scripts.
You can buy it direct from the publisher for 30%-off and get instant access to the code depot of Oracle tuning scripts.

Download your Oracle scripts now:

www.oracle-script.com

The definitive Oracle Script collection for every Oracle professional DBA

Oracle performance Tuning 10g reference poster

Oracle training & performance tuning books