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

In This Chapter

Estimating Index Pages

Managing Indexes

Creating and Dropping an Index in an Online Environment

Improving Performance for Index Builds

Estimating Memory Needed for Sorting

Estimating Temporary Space for Index Builds

Improving Performance for Index Checks

Indexes on User-Defined Data Types

Locking

Fragmentation Guidelines

Queries and the Query Optimizer

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