Query optimization

Question

Is there any way to optimise this query to something quicker?

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

Answer 1

Maybe using "DISTINCT business_id" rather than a group by..

Answer 2

Try this:

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