My apologies for not being an Oracle expert like yourself. Since I am
not aware of the "EXPLAIN PLAN" syntax I will research this syntax and
conduct some tests. Once completed I will post my findings back to
this Usenet group so others can learn. Please correct me if I'm
wrong, but learning from others is a goal of these Usenet groups.
Daniel Morgan <damorgan_at_exxesolutions.com> wrote in message news:<3EF9C9FA.2621AE77_at_exxesolutions.com>...
> Just_Buy wrote:
>
> > 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!
>
> Do your homework on your computer ... not in a usenet group.
>
> It would take you less time, and be substantially less aggravating to run EXPLAIN PLAN
> on these two statements than it has been to read this answer and get upset at my
> response which doubtless you will choose to do.
Received on Wed Jun 25 2003 - 18:33:31 CDT
