Re: Speeding up query that contains BETWEEN

From: David Saracini <dsaracini_at_yahoo.com>
Date: 10 May 2002 14:12:16 -0700
Message-ID: <45c4f95.0205101312.3dd5adff@posting.google.com>

> First the questions.
>
> 1. What version of Oracle?
> 2. Have you run Explain Plan to see if the indexes are being used?
> 3. Are your statistics kept current so the optimizer, assuming CBO,
> knows what it is doing?
>
> Then the suggestion.
>
> Assuming CBO, current statistics, and the correct index being used ...
> Try:
>
> a.street_no > 2140 and street_no < 2242
>
> but I wouldn't expect a dramatic improvement, if any.
>
> Daniel Morgan

Hello Daniel,

Well, the questions are hard to answer than you might think! :( Currently, I'm using 8.1.6 for *DEVELOPMENT* and the statistics are up to date. But, this is going into a commerical application, so I will not be in control of the database version or statistics. And just as a note, I don't see any real diffence with:

a.street_no > 2140 and street_no < 2242

Any advice will be appreciated!

Best Regards,

David Saracini Received on Fri May 10 2002 - 16:12:16 CDT