"What SARGable Means"

1. What does SARGable mean in the context of SQL Server?

It allows direct traversal of an index B-tree for matching rows. It guarantees the use of an index for every query. It is a term used for all types of SQL functions. It requires the use of SQL aggregates.

2. Which of the following predicates is non-SARGable?

WHERE OrderDate >= '2026-01-01' AND OrderDate < '2027-01-01' WHERE YEAR(OrderDate) = 2026 WHERE LastName = 'SMITH' WHERE Total > 1000 / 1.1

3. Why does a non-SARGable predicate lead to a bad estimate for query execution?

It doesn't use any indexes. The engine cannot determine how many rows will match due to lack of statistics. It executes too slowly. It produces syntax errors.

4. How can one rewrite the predicate `WHERE YEAR(OrderDate) = 2026` to make it SARGable?

WHERE OrderDate > '2026-01-01' WHERE OrderDate >= '2026-01-01' AND OrderDate < '2027-01-01' WHERE YEAR(OrderDate) > 2025 WHERE OrderDate = '2026-01-01'

Continue: "Functions on Columns and Date Ranges" → Review this lesson Retake quiz