Skip to main content
Journey Uncommon Logo
JourneyUncommon
mediumSQLcomposite and partial indexesSingle-choice MCQ

Given an index on (a, b, c), which WHERE clause leaves the index UNABLE to use column c for an index condition (it would have to filter c after the index scan)?

-- CREATE INDEX ON t (a, b, c);