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
In This Chapter
Allocating Shared Memory
Configuring UNIX Shared Memory
Freeing Shared Memory with onmode -F
Configuration Parameters That Affect Memory Utilization
Parameters That Affect Memory Caches
SQL Statement Cache
Session Memory
Data-Replication Buffers and Memory Utilization
Memory Latches
Encrypted Values
Effect of Configuration on I/O Activity
Table Performance Considerations
Index Performance Considerations
Locking
Fragmentation Guidelines
Queries and the Query Optimizer
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
