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:
Analyzing the access paths used in procedures will determine a set of entry points that allow the DBMS to traverse the database as efficiently as possible.
After the system has been designed, it is possible to remove any unused indexes from the Data Structure List.
Logic generated by CA Gen automatically maintains the correct values of data replicated in this way.
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.
Copyright © 2013 CA.
All rights reserved.
|
|