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
In This Chapter
Chunk and Dbspace Configuration
Placement of Critical Data
Configuration Parameters That Affect Critical Data
Configuring Dbspaces for Temporary Tables and Sort Files
Configuring Sbspaces for Temporary Smart Large Objects
Placement of Simple Large Objects
Parameters That Affect I/O for Smart Large Objects (IDS)
How the Optical Subsystem Affects Performance
Environment Variables and Configuration Parameters for the Optical Subsystem
Table I/O
Configuration Parameters That Affect Table I/O
Background I/O Activities
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
