MySQL Forums
Forum List  »  Optimizer & Parser

Advanced Search
New Topic

Re: MYSQL optimizer: Handling Subqueires
Posted by: Rakshit Trivedi
Date: August 20, 2009 09:34AM

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.

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Views
Written By
Posted
MYSQL optimizer: Handling Subqueires
3318
Rakshit Trivedi
August 17, 2009 05:50AM
Re: MYSQL optimizer: Handling Subqueires
2058
Rick James
August 18, 2009 06:38PM
Re: MYSQL optimizer: Handling Subqueires
2117
Rakshit Trivedi
August 19, 2009 03:33AM
Re: MYSQL optimizer: Handling Subqueires
2022
Rick James
August 19, 2009 09:01PM
Re: MYSQL optimizer: Handling Subqueires
2020
Rakshit Trivedi
August 20, 2009 09:34AM
Re: MYSQL optimizer: Handling Subqueires
2072
Rick James
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.