Re: Which is faster? <> or Between

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.

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