Maintaining Indexes

Periodically (e.g. monthly) we recommend performing a database reorganisation of all the indexes on all the tables in your database. This will rebuild the indexes so that the data is no longer fragmented. Fragmented data can cause SQL Server to perform unnecessary data reads, slowing down SQL Server’s performance. It will also update column statistics.

Re-indexing can only be performed against one table at a time (note that this will lock the table out for the duration of the re-indexing so 24/7 operations should be aware of this).

There are no specific re-indexing requirements for Keyfax although we recommend you consider re-indexing as part of your Maintenance Plan . There are some useful re-indexing hints/tips here.