Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Hints difference between AND_EQUAL, INDEX_JOIN and INDEX_COMBINE
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