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.
Subject
Written By
Posted
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.