Re: Can't understand why optimizer doesn't work properly :(
Well, does optimizer work like this:
1. Select outer query in `Messages` table scanning all rows.
2. Select subquery in `Ask` table filtering rows by condition Ask.DateTime < 20070710.
3. Filtering result in 1 step by condition Messages.Ask=Ask.Ask catching in 2 step.
If so, the first and second steps are independent. Why it can't change sequence step 1 and 2?
Edited 2 time(s). Last edit at 07/25/2007 11:49PM by Sergey Belov.
Subject
Views
Written By
Posted
3282
July 23, 2007 02:03PM
2248
July 23, 2007 07:21PM
2329
July 24, 2007 12:26AM
2141
July 24, 2007 02:08AM
2357
July 24, 2007 02:42AM
2089
July 24, 2007 06:02PM
Re: Can't understand why optimizer doesn't work properly :(
2203
July 25, 2007 11:10PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.