mysql - 查询优化

有没有什么方法可以将这个查询优化为更快的查询？

SELECT id FROM business
WHERE id NOT IN(SELECT business_id FROM business_community GROUP BY business_id)

最佳答案

试试这个：

SELECT id FROM business AS b
LEFT JOIN business_community bc ON bc.business_id = b.id
WHERE bc.business_id IS NULL

关于mysql - 查询优化，我们在Stack Overflow上找到一个类似的问题：https://stackoverflow.com/questions/4409693/