Part 1 of 5 · 1 min read
Why this page comes first
In this module you will
- Explain what a sargable predicate is, and why it matters.
- Identify common patterns that make a condition non-sargable, such as wrapping an indexed column in a function.
- Rewrite a common non-sargable condition into an equivalent, sargable form.
- Recognize an obfuscated condition that technically matches the data but blocks index use.
Every earlier page in this level assumed the optimizer could freely choose to use an index when one exists. This page covers an important exception. How a condition is written can make an existing, perfectly good index unusable, no matter how well it was designed.