Question
Which predicate is generally more sargable for an indexed OrderDate column?
Select an option. Your answer will be checked instantly.
Correct Answer: C. OrderDate >= @StartDate AND OrderDate < @EndDate
Explanation:
A sargable predicate leaves the indexed column unwrapped so the engine can seek a range.
Applying functions to the column often prevents efficient index navigation.
Leave a Reply