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

Home -> Community -> Mailing Lists -> Oracle-L -> RE: incorrect cardinality estimates when using "having 1=1"

RE: incorrect cardinality estimates when using "having 1=1"

From: Christian Antognini <Christian.Antognini_at_trivadis.com>
Date: Mon, 6 Jun 2005 18:08:30 +0200
Message-ID: <7F0C000A3ABA6241A10C9ABF37EEB46D0A4D0C@MSXVS01.trivadis.com>


Hi Vlado

>The developer is using "having 1=3D1" to simplify adding additional
>constraints to the having clause, if needed.
>
>Any idea why the difference and possible ways to solve this (without
>removing the having 1=3D1)?

IMHO=20
1) Simple solutions are good.=20
2) Simplistic solutions should be absolutely avoided.

Therefore, tell the developer to write good code.

HTH
Chris

--
http://www.freelists.org/webpage/oracle-l
Received on Mon Jun 06 2005 - 12:13:44 CDT

Original text of this message

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