SQL Practice Logo

SQLPractice Online

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;