MySQL Forums
Forum List  »  General

Re: Query time differences.
Posted by: Rick James
Date: August 29, 2015 11:49AM

Well, it seems to be using all of the index that it should:

For the inner query:
"used_key_parts": ["store_id", "qname_id"],
And outer:
"used_key_parts": ["qname_id", "node_id"],

So, I have to guess that a dependent subquery is a lot slower than the equivalent JOIN. I expected some diff, but you experienced a _huge_ difference is speed.

Options: ReplyQuote


Subject
Written By
Posted
August 25, 2015 05:46PM
August 25, 2015 06:20PM
August 26, 2015 10:40AM
August 27, 2015 11:16AM
Re: Query time differences.
August 29, 2015 11:49AM


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.