Index made it worse.
Why it happens
Wrong column order.
Why it matters
Optimizer chooses bad plans.
Smart fix
Index on filter columns first.
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.
Index made it worse.
Why it happens
Wrong column order.
Why it matters
Optimizer chooses bad plans.
Smart fix
Index on filter columns first.