mediumSQLcomposite and partial indexesSingle-choice MCQ

A composite index on (last_name, first_name) exists. A query filters WHERE first_name = 'Ann' only. Most planners will not use this index for an efficient seek. Why?

-- index: (last_name, first_name) SELECT * FROM people WHERE first_name = 'Ann';