Re: how Oracle processes index scans

From: Sybrand Bakker <postmaster_at_sybrandb.demon.nl>
Date: Fri, 20 Aug 1999 23:19:44 +0200
Message-ID: <935184009.27844.0.pluto.d4ee154e@news.demon.nl>

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