Practice Exercises on Indexing and Query Optimization

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.