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.
Subject
Views
Written By
Posted
1391
October 06, 2015 08:45AM
Re: Slow Join Performance
865
October 06, 2015 02:38PM
819
October 06, 2015 03:42PM
843
November 14, 2015 10:24AM
646
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.