Monitoring and Tuning Database Performance › Reducing I/O › Through Application Design

Through Application Design

Selecting the Optimal Path

The first step to determine if the application is optimally designed is to determine if it is accessing the data it needs, using the access path that will create the fewest number of I/Os. To determine if this is true:

1. Walk through the application and identify the actual transaction path
2. Review the existing database design and determine if there is a more efficient way to:
   • Access the needed records
   • Process the necessary relationships