mpacheco_brazil_at_hotmail.com wrote:
> 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
And depending on what you are doing, and how much of it, the result
could matter or be insignificant. Thus my advice to test.
--
Daniel A. Morgan
http://www.psoug.org
damorgan_at_x.washington.edu
(replace x with u to respond)
Received on Wed Feb 01 2006 - 12:19:04 CST
