NEW1.04.00 · Released 10 August 2011

NEWfinPOWER Connect

Released in

1.04.00

10 August 2011

1. Opened17 May
2. Closed1 Jun
3. Released10 Aug

Article 8839 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".