Sargable Predicate
A predicate is sargable when the engine can turn it into an index range or point lookup, e.g. col >= '2026-01-01'. Wrapping the column in a function (WHERE lower(email) = ...), applying arithmetic to it, a leading-wildcard LIKE, or an implicit type cast forces evaluation per-row and disables index seeks.
This Concept is waiting for its first lesson!
A predicate is sargable when the engine can turn it into an index range or point lookup, e.g. col >= '2026-01-01'. Wrapping the column in a function (WHERE lower(email) = ...), applying arithmetic to it, a leading-wildcard LIKE, or an implicit type cast forces evaluation per-row and disables index seeks.
Are you a teacher? Sign in to start contributing.
Sign In