Introduction

In This Introduction

About This Manual

Topics Beyond the Scope of This Manual

Types of Users

Software Dependencies

Assumptions About Your Locale

Demonstration Databases

New Features in Dynamic Server, Version 10.0

New Features in Dynamic Server, Version 9.4

Features From Dynamic Server, Version 9.3

Documentation Conventions

Additional Documentation

Accessibility

IBM Informix Dynamic Server Version 10.0 and CSDK Version 2.90 Documentation Set

Compliance with Industry Standards

IBM Welcomes Your Comments

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

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