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 are:

• Chapter 11, "SQL Tuning Overview"

• Chapter 12, "Automatic SQL Tuning"

• Chapter 13, "The Query Optimizer"

• Chapter 14, "Managing Optimizer Statistics"

• Chapter 15, "Using Indexes and Clusters"

• Chapter 16, "Using Optimizer Hints"

• Chapter 17, "SQL Access Advisor"

• Chapter 18, "Using Plan Stability"

• Chapter 19, "Using EXPLAIN PLAN"

• Chapter 20, "Using Application Tracing Tools"