Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Which is better?
Oracle9i Database Performance Tuning Guide and Reference, page 2-34:
How the CBO Evaluates the BETWEEN Operator
The optimizer always replaces a condition that uses the BETWEEN
comparison
operator with an equivalent condition that uses the >= and <=
comparison
operators. In the following example, the optimizer replaces the first
condition with
the second:
salary BETWEEN 2000 AND 3000
is transformed into
salary >= 2000 AND salary <= 3000 Received on Wed Feb 01 2006 - 09:30:22 CST