Level 9 - DistinguishedOptimization Questionsm1 optimizer cardinality internals
Optimization: Date Function vs Range Predicate
Choose the better query for optimizer/cardinality stability. Query A: SELECT campaign_id, COUNT(*) FROM events WHERE DATE(created_at) = CURRENT_DATE GROUP BY campaign_id; Query B: SELECT campaign_id, COUNT(*) FROM events WHERE created_at >= CURRENT_DATE AND created_at < CURRENT_DATE + INTERVAL '1 day' GROUP BY campaign_id;