Composite index for search
SQL
Easy
2 views
Problem Description
Customers are searched by (city, name). Create a composite index.
Output Format
DDL statement(s)
Sample Test Case
Input:
Customers(city, name)
Constraints
Order of columns matters
Official Solution
CREATE INDEX idx_customers_city_name ON Customers(city, name);
Solutions (0)
No solutions submitted yet. Be the first!
No comments yet. Start the discussion!