Fragmentation should not be the only factor which decides the Rebuild Index

Until now I was under the impression that fragmentation in the Index is the only factor which decides whether we should rebuild the index. As a rule of thumb we always recommend that when the avg_fragmentation_in_percent in the view¬† sys.dm_db_index_physical_stats¬† is between 5 and 30 We should reorganize the index and when the fragmentation is… Continue reading Fragmentation should not be the only factor which decides the Rebuild Index