Re: Which is faster? <> or Between

Just_Buy wrote:

> 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.

You missed the point. Everyone can run EXPLAIN PLAN. And what they will learn about is their specific system with their specific data. It is not necessarily transferrable to anyone else on a different system with
different data.

So by all means share ... but don't expect that the next time you do an application the result from this one will apply to the next.

--
Daniel Morgan
http://www.outreach.washington.edu/extinfo/certprog/oad/oad_crs.asp
damorgan_at_x.washington.edu
(replace 'x' with a 'u' to reply)