SQL Queries Suddenly Ignore Indexes

SQL

Indexes exist, scans happen.

Why
Implicit type conversions.

Fix

WHERE UserId = @UserId -- matching types

SQL Server — Nonclustered Index INCLUDE Is a Superpower

Post Views: 6