July 11, 2025 at 5:00 am
Comments posted to this topic are about the item Query Plan Regressions --
July 12, 2025 at 5:10 am
Thanks for posting your issue and hopefully someone will answer soon.
This is an automated bump to increase visibility of your question.
July 13, 2025 at 2:10 pm
Implicit conversions generally do not prevent an index seek. If a VARCHAR procedure parameter were to be compared to an NVARCHAR column, SQL Server must implicitly convert the column to NVARCHAR in order to evaluate the predicate. The conversion is reversed if the data type of the search parameter has a lower precedence than the data type of the search column. In this case, the optimizer selects an index using the available index. A useful example is given here: SQL Server Data Type Precedence
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply