Level 9 - DistinguishedOptimization Questionsm1 optimizer cardinality internals
Optimization: Late Filter vs Early Filter
Choose the better query shape for join-order/cardinality quality. Query A: SELECT u.id, e.total FROM users u JOIN (SELECT user_id, SUM(amount) total FROM events GROUP BY user_id) e ON u.id = e.user_id WHERE u.country = 'US'; Query B: SELECT u.id, e.total FROM users u JOIN (SELECT user_id, SUM(amount) total FROM events WHERE country = 'US' GROUP BY user_id) e ON u.id = e.user_id WHERE u.country = 'US';