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

In This Chapter

What Parallel Database Query (PDQ) Is

Structure of a PDQ Query

Database Server Operations That Use PDQ

Parallel Delete

Parallel Inserts

Parallel Index Builds

Parallel User-Defined Routines

Hold Cursors That Use PDQ

SQL Operations That Do Not Use PDQ

Update Statistics

SPL Routines and Triggers

Correlated and Uncorrelated Subqueries

OUTER Index Joins

Remote Tables

Memory Grant Manager

Allocating Resources for Parallel Database Queries

Managing Applications

Monitoring PDQ Resources

Improving Individual Query Performance

The onperf Utility on UNIX

Appendix A. Case Studies and Examples

Appendix B. Accessibility

Notices

Index