Re: Which is faster? <> or Between

It seems to me that the 'between' should work faster, as long as you don't have something like to_char, to_date, etc.

Correct me if I was wrong.

"Just_Buy" <ohbej_at_hotmail.com> wrote in message news:65275ae5.0306250757.b859f09_at_posting.google.com...
> Which of the following methods is faster for retrieving records within a
date range?
>
> Option A:
> Paid_Date >= '01-JAN-2003' AND Paid_Date <= '01-MAR-2003'
>
> Option B:
> Paid_Date BETWEEN '01-JAN-2003' AND '01-MAR-2003'
>
> Thanks!
Received on Thu Jun 26 2003 - 05:37:42 CDT