Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> RE: incorrect cardinality estimates when using "having 1=1"
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-lReceived on Mon Jun 06 2005 - 12:13:44 CDT