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