You can optimize a local database by compacting its SQLite® database file. Right-click the database node in The Databases Tree and select Compact () 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.