Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Hints difference between AND_EQUAL, INDEX_JOIN and INDEX_COMBINE

Hints difference between AND_EQUAL, INDEX_JOIN and INDEX_COMBINE

From: Jason <jungerle_at_gmail.com>
Date: 16 Dec 2005 11:12:21 -0800
Message-ID: <1134760340.979628.221540@z14g2000cwz.googlegroups.com>


Does anyone know the real difference between these hints? I've read the documentation in the "Oracle 9i Database Performance Tuning Guide and Reference" and the "Oracle 9i SQL Reference". Both seem to say the same thing just in different fashions, essentially, combining indexes for a better access path. INDEX_COMBINE appears to be only for bitmapped indexes so I assume the other 2 hints are for normal indexes (although the documentation doesn't state this explicitly).

Thanks!
Jason Received on Fri Dec 16 2005 - 13:12:21 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US