Article Details
Id:8839
Product:finPOWER Connect
Type:NEW
Version:1.04.00
Opened:17/05/2011
Closed:01/06/2011
Released:10/08/2011
Job: J007434

Database; new facility to rebuild Database Indexes added

A new facility to rebuild Database Indexes has been added. At present this is only available for Microsoft SQL Server databases.

The new facility is found under Tools, Database, Rebuild Database Indexes.

It allows you to review the indexes used, their fragmentation percentage and then rebuild or reorganise the index.

Note, you should setup SQL Server Maintenance Plans to Rebuild / Reorganise Indexes, Update Statistics and most importantly Backup the database. Note, it is recommended you use a recovery mode of "simple".