Optimizing Index Statistics

enaio® 10.10 »

Making extensive changes to the archive may cause it to work more slowly because the index tables of the database are no longer optimally maintained.

In this case, you may optimize the index statistics. You will find the Optimize index statistics function in the Actions menu.

You can also use the 'Database statistics update' automatic action.

If index statistics optimization does not produce any results, it is possible to delete all index tables or create new ones using enaio® editor.

Before optimizing the index statistics, create a backup copy of the database. You can only optimize the database index statistics if no user is accessing the database. You will need to restartenaio® server afterwards. All users will have restart enaio® client as well.