Recommendations for Optimizing the MES Database

For MES version 5.0, the MES database structure was optimized by adding new indices and removing other indices that were no longer needed. A fresh installation of MES version 5.0 or later will include the optimized index scheme.

However, these optimizations are not automatically applied when migrating MES databases for versions prior to version 5.0. This approach was used to prevent custom index optimizations that might have been applied to the MES database from being overwritten.

If your MES database has not had custom index optimizations and you would like to incorporate the version 5.0 optimization scheme, you can run an index optimization script that is installed as part of the MES database installation.

The following topics describe the optimization script and provide some additional optimization recommendations.