Optimizing the Physical Schema
After you load data into your database, first run Database Designer to create a physical schema that provides optimal query performance.
The first time you run Database Designer, make sure that Database Designer has representative queries and data on which to base the design. Then, create a comprehensive design.
Consider rerunning Database Designer to create an incremental design when:
- The data has changed significantly.
- You use different queries on a regular basis.
- You encounter performance issues with your queries.
- Your schema changes.
For more information, see Creating a Database Design in the Administrator's Guide.