Part IV

Optimizing SQL Statements

Part IV provides information on understanding and managing your SQL statements for optimal performance and discusses Oracle SQL-related performance tools.

The chapters in this part include:

• Chapter 11, "The Query Optimizer"

• Chapter 12, "Using EXPLAIN PLAN"

• Chapter 13, "Managing Optimizer Statistics"

• Chapter 14, "Using Indexes and Clusters"

• Chapter 15, "Using SQL Plan Management"

• Chapter 16, "SQL Tuning Overview"

• Chapter 17, "Automatic SQL Tuning"

• Chapter 18, "SQL Access Advisor"

• Chapter 19, "Using Optimizer Hints"

• Chapter 20, "Using Plan Stability"

• Chapter 21, "Using Application Tracing Tools"