Sunday, 8 September 2013

MySQL optimize a NOT IN query how to?

MySQL optimize a NOT IN query how to?

I have following query on mysql, query logic is correct however issue is
since there are over 10,000+ seeker emails and 24,000+ guest emails it
take long time to execute, is there a better way to do this same this ?
SELECT g.email, g.name
FROM guest g
WHERE g.type='guest'
AND g.email NOT IN (SELECT email FROM seeker GROUP BY email)
GROUP BY g.email

No comments:

Post a Comment