Counterintuitive but real.
Why
Optimizer chooses suboptimal plan.
Fix
Update statistics after index changes.
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.
Counterintuitive but real.
Why
Optimizer chooses suboptimal plan.
Fix
Update statistics after index changes.