Hacker News new | ask | show | jobs
by Sesse__ 409 days ago
IN is fine. The biggest problem comes with NOT IN, which has NULL semantics that makes life difficult for the planner. It is consistent but rarely what the user wants. NOT EXISTS is typically better there.