Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Index Rebuilds
Anand
> Range Scan is used if the leading columns of the index are part of the
> equality predicate.
Of course you are right, equality predicates that are not applied through a unique index Oracle uses a RANGE SCAN. When I wrote that sentence I was thinking to SQL and not to Oracle's execution plans. I.e. I was thinking to (un)bounded searches.
Regards,
Chris
-- http://www.freelists.org/webpage/oracle-lReceived on Sat Aug 05 2006 - 08:29:39 CDT
![]() |
![]() |