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

You have a composite index on (a, b, c). For which of these WHERE clauses can the index NOT be used to seek (jump straight to matching rows on the leading column)?

-- Index: CREATE INDEX idx ON t (a, b, c); -- Which query cannot do an index seek on the leading column?