Recommendations for Optimizing the MES DatabaseSave PDFSave selected topicSave selected topic and subtopicsSave all topicsShareShare to emailCopy topic URLLast UpdatedSep 06, 20241 minute readOperations and ExecutionManufacturing Execution System 2023 R2 The following sections provide some optimization recommendations: Fix database table fragmentation Monitor actual system usage Understand how many indexes to use Understand how often to rebuild and reorganize indexes Choose what to index Obtain additional assistance Related LinksFix database table fragmentationMonitor actual system usageUnderstand how many indexes to useUnderstand how often to rebuild and reorganize indexesChoose what to indexObtain additional assistance
The following sections provide some optimization recommendations: Fix database table fragmentation Monitor actual system usage Understand how many indexes to use Understand how often to rebuild and reorganize indexes Choose what to index Obtain additional assistance
The following sections provide some optimization recommendations: Fix database table fragmentation Monitor actual system usage Understand how many indexes to use Understand how often to rebuild and reorganize indexes Choose what to index Obtain additional assistance