TUNING


Setting database properties that optimize database performance

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.

Before you begin

Make sure you fully understand these database properties before changing their settings. For information, see Database properties that optimize database performanceProperly setting database properties can improve the performance of an active database. Setting database performance properties on many databases or on one, large, active database can also improve server performance. In addition, some of these property settings also help reduce the size of databases. Many of these properties require knowledge of application design, and the database designer often sets these properties when creating a database..

Procedure

1. Make sure you have Designer or Manager access in the database.

2. Do one of the following:


3. Enable as many of the following properties as possible: 4. Disable as many as possible of the following properties: 5. If you select any of the following properties, compact the database for the property to take effect.
Related concepts
Access levels in the ACL

Related reference
Database properties that optimize database performance