The Maintenance dialog offers the ability to optimize database performance by reorganizing or rebuilding the indexes for that database. Over time, modifications such as insert, update or delete operations can result in fragmented indexes in the database. In this case, indexes have pages in which the logical ordering, based on the key value, does not match the physical ordering inside the data file. Indexes that are heavily fragmented can cause query performance degradation and can cause your application to respond slowly.

Index fragmentation can be remedied by either reorganizing or rebuilding an index. Reorganization of an index physically reorganizes the leaf nodes of the index. Rebuilding an index drops the existing index and completely recreates the index.

Note: More experienced administrators may choose to manage their database themselves using the tools provided by the SQL server instead of the functions available on this dialog. It is recommended though that less experienced administrators use this maintenance dialog. A reorganization of indexes should be run every 1-3 months, and a rebuild every 3-12 months.

To initiate a reorganization or rebuilding of database indexes, complete the following steps:

Updated: 06/12/2011  Page url: http://www.perfectforms.com/Documentation/manual/html/?fg_database_index_optimization.htm
PerfectForms™ -- forms software, workflow software, and business process management