4 ms·
It's the optimizer caching the query plan as a parameterized query. It's not re-planning the index lookup on every execution.
by wvenable 7mo ago
It's the optimizer caching the query plan as a parameterized query. It's not re-planning the index lookup on every execution.
- SigmundA 7mo agoThe parameter type is part of the cache identity, nvarchar and varchar would have two cache entries with possibly different plans.
- deleted 7mo ago[deleted]