Practice Exercises on Indexing and Query Optimization
Explore hands-on exercises focused on indexing and query optimization to enhance database performance. Learn to create indexes, analyze query plans, and build materialized views that improve efficiency and reporting for common business scenarios.
Problem 1
Management wants a report of all orders that were delivered late. The query will filter by DeliveryStatus = 'Delivered' and LateDelivery = TRUE. Create an appropriate index on the Orders table to speed this up.
...