By default, newly created databases are not optimized for performance. This is especially true when you create databases designed for Web clients. Therefore, you must modify some settings to improve database performance and reduce database size. Specifically, various settings on the Advanced Options tab of the database Infobox help improve database performance.
The following sections outline settings that can be manipulated to improve performance.