SQL Optimization Guide

Query Execution Process
Optimization Process
Updating Statistics
Reviewing and Modifying a Table Definition
Typical SQL Optimization Methods
SQL Statement Rewriting Rules
Adjusting Key Parameters During SQL Tuning
Hint-based Tuning
Routinely Maintaining Tables
Routinely Recreating an Index
Configuring SMP

Parent topic: Performance Tuning