Update the target database indexes

administrator

Note

Depending on the size of your FactoryLogix database, some of the database utilities may take longer than others to run, so plan carefully before running the utilities.

Database indexes are used to quickly locate data without having to search all rows in a database table every time it is accessed. Indexes can be created using one or more columns of a database table, providing the means for both rapid random lookups and a way to access ordered records in the database efficiently. Indexing optimizes database performance by minimizing the number of disk access requests required whenever a query is processed. In Server Management, you can update database indexes to ensure optimal database efficiency and performance. Since an optimized index can dramatically speed up data retrieval, as your FactoryLogix database grows, it is essential to update the indexes periodically to maintain peak performance.

Log onto the server or a machine where FactoryLogix Server Management is already installed. (The login account should have administrative rights to the database server if you are using Windows authentication.)
Start FactoryLogix Server Management.
Select the Database Utilities button.
In the Database Utilities window, select a database from the Select Target Database drop-down, then select Update Target Database Indexes.

When the indexes are updated successfully, you will see a confirmation message.