Stop Criteria for Sql Execution
- From: "Khedr, Waleed" <Waleed.Khedr@xxxxxxx>
- To: <oracle-l@xxxxxxxxxxxxx>
- Date: Mon, 7 Mar 2005 11:38:25 -0500
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
--
//www.freelists.org/webpage/oracle-l
Other related posts:
