On Apr 21, 7:09 am, Daiesh <mcavenkad...@gmail.com> wrote:
> Hi All,
>
> How do speed up the index range scan in Oracle?
>
> Advance wishes!!!..
>
> Thanks
> Daiesh
Why do you 'need' to 'speed up the index range scan'? Why do you
think that is the bottleneck? I'd be using autotrace instead of
simply using explain plan to see what I/O activity your generating
with that query. The index range scan is probably running as fast as
possible but it's generating a large result set to filter on another
criteria. Filtering large volumes of data will consume time, time you
might be able to save with a concatenated index.
David Fitzjarrell
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google
Groups "Oracle PL/SQL" group.
To post to this group, send email to Oracle-PLSQL@googlegroups.com
To unsubscribe from this group, send email to
oracle-plsql-unsubscr...@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/Oracle-PLSQL?hl=en
-~----------~----~----~----~------~----~------~--~---
