mardi 10 février 2015

REORGANIZE seems to work as well as REBUILD all the time


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