Please ensure Javascript is enabled for purposes of website accessibility
Powered by Zoomin Software. For more details please contactZoomin

AVEVA™ Manufacturing Execution System 2023 R2

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.

TitleResults for “How to create a CRG?”Also Available in