It sounds like you are missing indexes.
Please post the results of -
SHOW CREATE TABLE ImportLiebermansStep3Add;
- and -
SHOW CREATE TABLE ProductsOld;
- and we can tell you if you have enough indexes or not.
Yours,
Shawn Green
Database Administrator
Unimin Corporation - Spruce Pine
Jeff
Why are you doing a LEFT JOIN instead of a INNER JOIN
right now you are getting all rows from first table regardless of match
condition so all of the rows for
a.ProductID FROM ImportLiebermansStep3Add
are being returned
try the inner join instead
Martin
- Original Message -
From: "Jeff
