Index Rebuild vs. Coalesce vs. Shrink Space (Pigs – 3 Different Ones)

(Richard Foote) Previously, I discussed how an ALTER INDEX … COALESCE is going to be less expensive in terms of using resources than an equivalent ALTER INDEX … SHRINK SPACE COMPACT (or ALTER INDEX … SHRINK SPACE) as the Coalesce doesn’t have to concern itself with ensuring all leaf blocks at the p

Read More - Register for Free Membership