$ ./guess_the_languageSQL & Databases
SQL & Databases · medium · #20

Which filter can use this index as a direct seek?

CREATE INDEX idx_name
  ON people (last_name, first_name);
  1. WHERE last_name = 'Lee'
  2. WHERE first_name = 'Ann'
  3. WHERE age = 30
  4. WHERE first_name LIKE 'A%'
A composite B-tree is sorted by its leftmost column first, so a seek needs a predicate on last_name.
Play SQL & Databases ▸