You should be converting the constants in both cases to dates by using
to_date. It would be very efficient and the code would be less prone to
breaking if he did that.
Jim
--
Replace part of the email address: kennedy-down_with_spammers_at_attbi.com
with family. Remove the negative part, keep the minus sign. You can figure
it out.
"M" <noreply_at_noreply.com> wrote in message
news:bdeja0$23h2$1_at_news.hgc.com.hk...
> 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 - 09:58:18 CDT
