17. Improving Database and Query Performance : Design Issues and Performance
 
Share this page                  
Design Issues and Performance
Good query performance requires planning.
Carefully plan the design of the following:
Storage structures and indexes
Keys
Queries
For help in identifying performance issues, see the chapters “Ensuring Data Integrity,” “Maintaining Databases,” “Maintaining Storage Structures,” and “Using the Query Optimizer.”
Other important design issues are:
Database design
Validation checks and integrities
Grants and views
Application design