Previous Topic: Change Database NamesNext Topic: Rearrange the Database Structure


Optimize the Data Structure Design

In most cases, CA Gen supports tuning database performance without changing the data model. Changes should be reviewed with a specialist for the target database.

The following list details some of the optimizations that can be performed in the Data Structure List:

Some optimization needs to be performed before procedure design begins, but some can only be completed after the detailed design has been completed. The DBMS expert will need to make a least two “passes” over the Data Structure List and Data Store List before the physical definition of the database is converted into DDL statements.

The optimizations should be performed to increase performance for the predominate processing pattern, since for every gain in one area, losses may be sustained in others.