When using a database whose data is file stored in multiple segments, the index tables might be split between the different segments. This may degrade the performance of your database
If you want to make sure that your database is operating at its best potential, or if you notice a slow down in its operation, you need to perform a "recover by tag" operation on your data file using 4D Tools. The data file will be reorganized so that index tables are not noticeably fragmented.
Note: If the option "Completely Deleted" is deselected for any table in the table properties dialog, it is necessary to compact the data file before performing a recover by tag.
Note: Compacting a data file will only remove unused spaces in the data file and will not optimize the data file like recover by tags will.