Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Which is better?

Re: Which is better?

From: DA Morgan <damorgan_at_psoug.org>
Date: Wed, 01 Feb 2006 10:19:04 -0800
Message-ID: <1138817939.129910@jetspin.drizzle.com>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US