SQL Practice Logo

SQLPractice Online

Level 6 - ExpertOptimization Questionsm2 performance schema

Optimization: Partition Pruning Candidate

Choose the better query for a monthly-partitioned `orders(order_date, customer_id, total_amount)` table. Query A: SELECT * FROM orders WHERE DATE(order_date) = '2026-03-01'; Query B: SELECT customer_id, total_amount FROM orders WHERE order_date >= '2026-03-01' AND order_date < '2026-03-02';