hard20 pts · first answer countspartitioningquery-tuning
Partition pruning
The orders table is range-partitioned by order_date, one partition per month for many years. Which WHERE clause lets the planner skip all partitions except March 2026?
Discussion 0
Join free to post in the discussion.
Related questions
- Finding slow MySQL queriesDatabase Administrator
- Composite index column orderDatabase Administrator
- Reading an EXPLAIN ANALYZE planDatabase Administrator
- Slow deep paginationDatabase Administrator
- Which query to tune firstDatabase Administrator
- Sort Method: external mergeDatabase Administrator
- Bad plan right after a bulk loadDatabase Administrator
- Counting a huge table quicklyDatabase Administrator