Fixing Database Table Fragmentation

To fix table fragmentation, any MES database that has a page count of 1,000 or greater will be automatically evaluated for reindexing when it is created or migrated.

• If an index's fragmentation is greater than 5% but less than or equal to 30%, the index will be reorganized.

• If an index's fragmentation is greater than 30%, the index will be rebuilt.