mysql query select not in 运行太慢

Question

我正在尝试查询产品表中未重复的 SKU:

SELECT entity_id, 
       sku 
FROM   catalog_product_entity 
WHERE  sku NOT IN (SELECT sku 
                   FROM   catalog_product_entity 
                   GROUP  BY sku 
                   HAVING Count(*) > 1) 

但是它运行起来很慢，连我的电脑都挂了。任何人都有更好的解决方案来优化这个查询，请帮帮我!

Answer 1

下面的查询是否实现了相同的目的？

SELECT entity_id, 
       sku 
FROM   catalog_product_entity 
GROUP  BY sku 
HAVING Count(*) = 1