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

Optimizer Directives

In This Chapter

What Optimizer Directives Are

Reasons to Use Optimizer Directives

Guidelines for Using Directives

Preparation for Using Directives

Types of Directives That Are Included in SQL Statements

Configuration Parameters and Environment Variables for Directives

Directives and SPL Routines

Using External 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