Fix database table fragmentation
- Last UpdatedOct 18, 2024
- 1 minute read
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.