Bits of .NET

Many rebuild indexes blindly.

❌ Bad Habit

ALTER INDEX ALL ON Orders REBUILD;

✅ Smart Rule

• Fragmentation < 5% → do nothing

• 5–30% → REORGANIZE

• 30% → REBUILD

ALTER INDEX IX_Orders_Date ON Orders REORGANIZE;

Why
Rebuild = blocking + log growth.