You can optimize a local database by clicking Compact (
) in the
Maintenance section of the
Home toolbar to open the
Compact dialog box. The
File size field shows the current size of the SQLite
® database file, and the
Estimated file size after compacting field shows the estimated size after the file has been compacted. Click
OK to compact the file. This may take a few seconds up to several minutes depending on the size of the database file.