Introduction

Database optimization is a process at which data inside a database file is reallocated and united in order to fasten work of the database. This process is equivalent to the process of defragmentation of hard disks.

To perform optimization, select File > Database Maintenance from the menu.

Optimization

There are two buttons on the 'Optimization' tab:

• Analyze - scans the database to check if optimization is needed. At that, blue area determines data that does not need optimization, and yellow and red - fragmented data that needs to be optimized.
• Optimize - performs database optimization.