Phone (800) 766-1884 for immediate Oracle support & training
Free Oracle Tips

Home Home
Oracle Monitoring
Growth Monitoring
Emergency DBA Support
Installs & Upgrades
Oracle Migration
Oracle Support Plan
Oracle SQL Tuning
Oracle Performance Tuning

 Our Remote DBA Clients

 

Free Oracle Tips


 
HTML Text

Free Oracle App Server Tips


 
HTML Text

 

   
  Oracle Tips by Burleson

dba_join_ind_columns

DBA_JOIN_IND_COLUMNS
Join Index columns comprising the join conditions
------------------------------------------------------------------------------------
INDEX_OWNER 	VARCHAR2 	Index owner
INDEX_NAME 	VARCHAR2 	Index name
INNER_TABLE_OWNER 	VARCHAR2 	Table owner of inner table (table closer to the fact table)
INNER_TABLE_NAME 	VARCHAR2 	Table name of inner table (table closer to the fact table)
INNER_TABLE_COLUMN 	VARCHAR2 	Column name of inner table (table closer to the fact table)
OUTER_TABLE_OWNER 	VARCHAR2 	Table owner of outer table (table closer to the fact table)
OUTER_TABLE_NAME 	VARCHAR2 	Table name of outer table (table closer to the fact table)
OUTER_TABLE_COLUMN 	VARCHAR2 	Column name of outer table (table closer to the fact table)

Burleson Oracle consulting & training



 

 

WISE Oracle monitoring software
 

 

Oracle forum for DBA 

 

Rampant TechPress Oracle book publisher

image 

  

 

E-mail us for BC Oracle support:   

Copyright © 1996 -  2012 by Burleson Enterprises. All rights reserved.

Oracle® is the registered trademark of Oracle Corporation.