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

In This Chapter

The Query Plan

Factors That Affect the Query Plan

Time Costs of a Query

Memory-Activity Costs

Sort-Time Costs

Row-Reading Costs

Sequential Access Costs

Nonsequential Access Costs

Index Lookup Costs

In-Place ALTER TABLE Costs

View Costs

Small-Table Costs

Data-Mismatch Costs

Encrypted-Value Costs

GLS Functionality Costs

Network-Access Costs

SQL Within SPL Routines

Trigger Execution

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