Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: how Oracle processes index scans
No,
It finds the lower value in > cases and the higher value in < cases, and
works all the way up (or down).
Hth,
Sybrand Bakker, Oracle DBA
Steve Perry <sperry_at_sprynet.com> wrote in message
news:37BDE0BE.48D770EE_at_sprynet.com...
> Does anyone know how Oracle processes a range scan on an index? Does it
> find the high and low values in the index and work toward the center
> or???
> What about other types of index access?
>
> Thanks,
> steve
>
Received on Fri Aug 20 1999 - 16:19:44 CDT