Databases

Sargable

A predicate that can use an index seek - the indexed column appears bare, not wrapped in a function.

Why interviewers ask about it

WHERE YEAR(created) = 2026 scans; the date-range rewrite seeks. Same for a leading-wildcard LIKE. This is the most common accidental full scan.

This term is part of the free Python Full-Stack interview preparation module - browse the full glossary for every definition.