Which filter can use this index as a direct seek?
CREATE INDEX idx_name ON people (last_name, first_name);
WHERE last_name = 'Lee'WHERE first_name = 'Ann'WHERE age = 30WHERE first_name LIKE 'A%'
A composite B-tree is sorted by its leftmost column first, so a seek needs a predicate on
Play SQL & Databases ▸
last_name.