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

Parallel Database Query

Improving Individual Query Performance

In This Chapter

Using a Dedicated Test System

Displaying the Query Plan

Improving Filter Selectivity

Updating Statistics

Improving Performance with Indexes

Replacing Autoindexes with Permanent Indexes

Using Composite Indexes

Using Indexes for Data Warehouse Applications

Dropping and Rebuilding Indexes After Updates

Improving Performance of Distributed Queries

Improving Sequential Scans

Reducing the Impact of Join and Sort Operations

Optimizing User-Response Time for Queries

Optimizing Queries for User-Defined Data Types

SQL Statement Cache

Monitoring Sessions and Threads

Monitoring Transactions

The onperf Utility on UNIX

Appendix A. Case Studies and Examples

Appendix B. Accessibility

Notices

Index