Optimize Database

Select this option to optimise the Database Indexes and improve performance within Ostendo.   You should note that the 'Backup and Restore' routine (Executable 'Dbutils.exe' which can be found under the Ostendo Folder) will also do this as part of its backup/restore process. 

This optimize function resets the index statistics of the database. This should be done periodically because inserting, updating,and deleting records changes these statistics.

Firebird calculates it when index is first created and when the database is restored from backup.

So regular backup and restore of the database will optimize the database. But between the scheduled backup/restores, it may be necessary to use this function to reset the index statistics so the database perform efficiently.