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: <mpacheco_brazil_at_hotmail.com>
Date: 1 Feb 2006 07:30:22 -0800
Message-ID: <1138807822.626541.261670@o13g2000cwo.googlegroups.com>


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

Original text of this message

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