Re: MYSQL optimizer: Handling Subqueires
Ok, got your point.
But then this approach of the working of optimizer seems to be different from other databases. Because in other databases, we do not find such large EXPLAIN times and execution is carried out after complete compilation rather than both these processes occurring simultaneously.
So, what is the benefit that MYSQL database engine achieves by using this approach?
Thanks.
Subject
Views
Written By
Posted
3401
August 17, 2009 05:50AM
2111
August 18, 2009 06:38PM
2152
August 19, 2009 03:33AM
2088
August 19, 2009 09:01PM
Re: MYSQL optimizer: Handling Subqueires
2061
August 20, 2009 09:34AM
2122
August 20, 2009 10:33AM
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.