Monitoring and Tuning Database Performance › Reducing I/O

Reducing I/O

I/O can be reduced through:

• Caching files in memory
• Database reorganization
• Application design
• Database design
• The UPDATE STATISTICS utility command (for SQL-accessed databases)

Each of these is discussed as follows.