Level 6 - ExpertOptimization Questionsm4 domain design cases
Optimization: Anti-Join for Churn Candidates
Pick the better churn-candidate query. Query A: SELECT u.id FROM users u LEFT JOIN sessions s ON u.id = s.user_id WHERE s.user_id IS NULL; Query B: SELECT u.id FROM users u WHERE NOT EXISTS (SELECT 1 FROM sessions s WHERE s.user_id = u.id);