IBM Informix Dynamic Server Performance Guide
Introduction
Performance Basics
Performance Monitoring and the Tools You Use
Effect of Configuration on CPU Utilization
Effect of Configuration on Memory Utilization
Effect of Configuration on I/O Activity
Table Performance Considerations
Index Performance Considerations
Locking
Fragmentation Guidelines
Queries and the Query Optimizer
In This Chapter
The Query Plan
Factors That Affect the Query Plan
Statistics Held for the Table and Index
Filters in the Query
Indexes for Evaluating a Filter
Effect of PDQ on the Query Plan
Effect of OPTCOMPIND on the Query Plan
Effect of Available Memory on the Query Plan
Time Costs of a Query
SQL Within SPL Routines
Trigger Execution
Optimizer Directives
Parallel Database Query
Improving Individual Query Performance
The onperf Utility on UNIX
Appendix A. Case Studies and Examples
Appendix B. Accessibility
Notices
Index
Introduction
