Choose the right index for a query
SQL
Medium
2 views
Problem Description
Query: SELECT * FROM Orders WHERE customer_id=? AND order_date BETWEEN ? AND ?. Suggest an index and write it.
Output Format
DDL statement(s)
Sample Test Case
Input:
Orders(customer_id, order_date)
Constraints
Composite index for filter columns
Official Solution
CREATE INDEX idx_orders_customer_date ON Orders(customer_id, order_date);
Solutions (0)
No solutions submitted yet. Be the first!
No comments yet. Start the discussion!