Re: "between" vs. ">= and <="

On 14.11.2008 17:16, sybrandb wrote:
> On 14 nov, 17:10, Robert Klemme <shortcut..._at_googlemail.com> wrote:

>> a client of us requested to replace ">= and <=" with "between" with a
>> TIMESTAMP column. Unfortunately I am still waiting for his
>> justification...  In the meantime I thought I do some researching.
>> Personally I cannot think of any reason why one or the other should be
>> more efficient.

> The request may be sensible.
> In the 'old' days I had

When (i.e. which Oracle version) was that?

> where a=... and date_column>= and date_column<= and c=...
>
> seeing optimized as
> where (a= and date_column>=) and (datum_column<=) and c=
>
> And gone was the index usage!
> Between ... and ... is treated as one construct.

Spooky. Thanks for the hint. I'll do another test with an additional column.

Kind regards

        robert Received on Fri Nov 14 2008 - 11:46:13 CST