The Index File Optimiser utility allows you to increase the speed of file access for searching records, reports etc. It does this by rebuilding and packing the index files in the most efficient order. You can select to optimise all or selected files in the current company.
The Index File Optimiser will not detect errors or remove any corrupted data. To get the most benefit from this process you must run the Database System Status check utility and also run the Compress Database utility prior to running the Index File Optimiser.
When should the Index File Optimiser be run
After the initial details and balances are entered for a module
After a number of deletions.
To increase the speed of accessing information etc.
Running the Index File Optimiser utility
Exit all users from the Attaché Company you wish to check.
Run the Database System Status check utility (as per link above).
Run the Compress Database utility (as per link above).
Go to Tools, Company, Data Checks, File Index Optimiser.
Choose All (F5) to select all tables. This will select all Index files.
Choose Accept (F9) to begin the status check.
When finished, the message Index Optimiser Complete is displayed.
Review the results on the screen. When the database system status check reaches the end and displays Ok in the Status column to the files displayed on the screen, then no errors have been detected. There is no need to page up to view every file. If an error was detected, then the database system status check will reposition to the display the file with the error.
If errors are detected, a message also displays in the Status column, alongside the affected table.
If errors are found, restore your most recent backup and re-do all work since that backup was taken. See: Restore an archive backup file. However, it is most likely you will NOT have errors if the Database System Status check did not experience any errors.
If you have been experiencing repeated problems, ensure that you run the database system status check again on the restored data before re-doing any work.
Note that if you select Stop (Esc) while the status checking is in progress, the check on the current table may not be completed. You may need to re-run the process to verify the status of this table.
If you are finished running the check, you can click the Close (Esc) button to exit the screen.
📌Note: If you select Stop during the optimise, the current file optimise will not complete. If required, you will need to re-process the optimise on this file.