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
In This Chapter
Placing Tables on Disk
Estimating Table Size
Managing the Size of First and Next Extents for the tblspace
tblspace
Managing Sbspaces
Estimating Pages That Smart Large Objects Occupy
Improving Metadata I/O for Smart Large Objects
Monitoring Sbspaces
Changing Storage Characteristics of Smart Large Objects
Managing Extents
Changing Tables
Denormalizing the Data Model to Improve Performance
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