Your column is VARCHAR. Your app is passing an INT. SQL Server quietly converts every value in the column to compare them. Index? Useless. Table scan? Hello again. The NVARCHAR vs VARCHAR one is ...
Some results have been hidden because they may be inaccessible to you
Show inaccessible results