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

Home -> Community -> Mailing Lists -> Oracle-L -> Stop Criteria for Sql Execution

Stop Criteria for Sql Execution

From: Khedr, Waleed <Waleed.Khedr_at_FMR.COM>
Date: Mon, 7 Mar 2005 11:38:25 -0500
Message-ID: <42BBD772AC30EA428B057864E203C9990123375C@MSGBOSCLF2WIN.DMN1.FMR.COM>


Why does Oracle have to execute the sql and scan data in a table for a sql like this:

Select * from table
Where column1 is null and column1=3D10

Or=20

Select * from table
Where column1=3D10 and column1=3D20

All the research money going to optimize the optimizer, and still can't take care of simple stuff like this.

Am I missing something?

I will probably start searching for smarter databases :)

Waleed

--
http://www.freelists.org/webpage/oracle-l
Received on Mon Mar 07 2005 - 11:41:42 CST

Original text of this message

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