How to force oracle to use index range scan?
Posted
by wsb3383
on Stack Overflow
See other posts from Stack Overflow
or by wsb3383
Published on 2010-03-18T21:58:48Z
Indexed on
2010/03/18
22:01 UTC
Read the original article
Hit count: 356
Oracle
Hi, all.
I have a series of extremely similar queries that I run against a table of 1.4 billion records (with indexes), the only problem is that at least 10% of those queries take > 100x more time to execute than others. I ran an explain plan and noticed that the for the fast queries (roughly 90%) Oracle is using an index range scan (on my created), while on the slow one, it's using a full index scan.
Is there a way to force Oracle to do a an index range scan?
Thanks!
© Stack Overflow or respective owner