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