Bits of .NET

SQL ignores indexes when:

• Data type mismatch

• Implicit conversion

Example problem:

WHERE UserId = '123' -- string

✅ Fix

WHERE UserId = 123 -- int

Golden rule
Indexes only work when types match exactly.