MySQL Forums
Forum List  »  Performance

Re: Slow Join Performance
Posted by: Rick James
Date: October 06, 2015 02:38PM

Please provide SHOW CREATE TABLE for both tables. For one thing, I want to check that the collations are the same.

Your query is trying to find out how many of `name` are common between the two tables? And it will include counting dups multiple times? Or did you mean to be doing something else?

Note that if there are 7 "xyz" in one table and 20 in the other, the COUNT(*) will be bumped up by 140.

Options: ReplyQuote


Subject
Views
Written By
Posted
1304
October 06, 2015 08:45AM
Re: Slow Join Performance
782
October 06, 2015 02:38PM
762
October 06, 2015 03:42PM
789
November 14, 2015 10:24AM
572
November 26, 2015 02:39PM


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.