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".