Part I
Writing and Tuning SQL

Part I provides information on understanding and managing your SQL statements for best performance. It is best to read these chapters in the order in which they are presented.

The chapters in this part are:

• Chapter 1, "Introduction to the Optimizer"

• Chapter 2, "Optimizer Operations"

• Chapter 3, "Gathering Optimizer Statistics"

• Chapter 4, "Understanding Indexes and Clusters"

• Chapter 5, "Optimizer Hints"

• Chapter 6, "Optimizing SQL Statements"

• Chapter 7, "Using Plan Stability"

• Chapter 8, "Using the Rule-Based Optimizer"