TUNING
You can set database properties to optimize database performance and to reduce database size. Set database performance properties by opening the Database Properties box on an existing database or as you create a database.
Make sure you fully understand these database properties before changing their settings.
Procedure
1. Make sure you have Designer or Manager access in the database.
2. Do one of the following:
Note: You can use the Compact task with specific options to enable or disable the above three properties and then compact the database.
Related reference Database properties that optimize database performance