Home Forums SQL Server 2008 SQL Server 2008 - General High Fragmentation Index ... RE: High Fragmentation Index ...
SQLisAwe5oMe
SSChampion
Points: 14047
More actions
July 13, 2014 at 7:29 pm
#1729010
Hi, just curious, how big is this table?
If the table is very small, table scan is sometimes faster than seek...so, that's why the fragmentation is getting high again.
Experts, correct me if I'm wrong.
Regards,SQLisAwe5oMe.