WHERE Status = 1 OR Status = 2
❌ Effect
Index seek → index scan.
✅ Fix
Rewrite with IN or UNION.
Bits of .NET
Daily micro-tips for C#, SQL, performance, and scalable backend engineering.
Daily micro-tips for C#, SQL, performance, and scalable backend engineering.
WHERE Status = 1 OR Status = 2
Index seek → index scan.
Rewrite with IN or UNION.