Why does a function on a column stop an index from helping?
Define sargable predicates and the index you would add for a real filter.
Engineers who own data access
Indexes, isolation, and the query plan you would actually ask for in a review.
Define sargable predicates and the index you would add for a real filter.
Name the anomaly you are preventing before you name the level.