Functional index for case-insensitive search
SQL
Hard
2 views
Problem Description
Create an index to speed up WHERE LOWER(name)=LOWER(?) on Customers.
Output Format
DDL statement(s)
Constraints
Functional index support varies
Official Solution
CREATE INDEX idx_customers_lower_name ON Customers(LOWER(name));
Solutions (0)
No solutions submitted yet. Be the first!
No comments yet. Start the discussion!