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 ...