SQL
Efficiently Check for Related Record Existence with EXISTS
Discover how to use the SQL EXISTS operator for performance-optimized checks to see if related records exist, often outperforming JOINs for simple existence.
SELECT u.id, u.username, u.email
FROM users u
WHERE EXISTS (
SELECT 1
FROM orders o
WHERE o.user_id = u.id
AND o.order_date >= CURDATE() - INTERVAL 30 DAY
);
How it works: This SQL query uses the EXISTS operator to efficiently retrieve users who have placed an order in the last 30 days. The EXISTS clause stops scanning as soon as it finds one matching row in the subquery, making it highly efficient when you only need to confirm existence, not retrieve the actual related data. This often performs better than a JOIN followed by DISTINCT for simple existence checks.