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:

For more information, see Creating a Database Design in the Administrator's Guide.