Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Which is faster? <> or Between
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 Wed Jun 25 2003 - 10:57:45 CDT