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

Improving Performance of Distributed Queries

Improving Sequential Scans

Reducing the Impact of Join and Sort Operations

Avoiding or Simplifying Sort Operations

Using Parallel Sorts

Using Temporary Tables to Reduce Sorting Scope

More Memory for Queries with Hash Joins, Aggregates, and Other Memory-Intensive Elements

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