On this MSDN Page it says if you should reorganize or rebuild based on the amount of fragmentation:
5% to 30% -> ALTER INDEX REORGANIZE
Over 30% -> ALTER INDEX REBUILD WITH (ONLINE = ON)*
However, we have noticed that even with really high fragmentation (over 95%) on large and small tables, REORGANIZE works fine. (The fragmentation goes down to less that 1%).
Why does the MSDN page say this? Is it not supposed to work like it is for me?
Or is there a drawback I am missing? (A hidden problem if I don't rebuild?)
Aucun commentaire:
Enregistrer un commentaire