Optimize Sort Operations

Objectives

Operations Requiring Sorting

Sort Process

Sort Area and Parameters

Sort Area and Parameters

Sort Process and Temporary Space

Temporary Space Segment

Tuning Sort Operations

Avoiding Sort Operations

Diagnostic Tools

Diagnostics and Guidelines

Monitoring Temporary Tablespaces

Temporary Tablespace Configuration

Summary