What does it mean to compact and repair your database? What is the difference between a single

The utility of the compact database decreases the size of the given database by making a definite copy of our database in the system while likewise free the given database by overabundance space created by erasing and modifying the information.

Compacting is one of the best way to diminish the physical size of the database. The compact is the process which compress the database and also precise the information of our database.

It basically makes our data small by eliminating some extra space in the system and repairing process mainly improve the performance of the database.

The main difference between the single compact and a compact on close means that the database will be automatically compact when we close the database and single compact means we select the particular database to make it compact.