The utility also updates table statistics to reflect database characteristics of the restructured data.
The Compact Utility restructures table records and objects, and then stores them in successive memory blocks, eliminating wasted space. Compacting is the only way to reduce the size of your database. The Compact Utility reduces the physical size of your database by making an exact duplicate of the database while also ridding the database of any excess space created by deleting and modifying data.