Index fragmentation calculation

If the page count for an index is small, there is no need to rebuild that index. Fragmentation on indexes with a small page count would hardly cause any I/O issues. When the index is small, pages are most likely to be in memory, and no physical I/O would be required. There is hardly any performance improvement in rebuilding indexes with a small page count.

For automatic database maintenance, manual fragmentation analysis, or manual fragmentation rebuild, FactoryTalk AssetCentre only calculates the indexes with more than 1,000 pages.