Part II
Application Design Tuning for Designers and Developers

Part II provides information on designing and tuning applications for optimal performance. The chapters in Part II are:

• Chapter 3, "Application and System Performance Characteristics"

• Chapter 4, "The Optimizer"

• Chapter 5, "Using EXPLAIN PLAN"

• Chapter 6, "Using SQL Trace and TKPROF"

• Chapter 7, "Using Optimizer Hints"

• Chapter 8, "Gathering Statistics"

• Chapter 9, "Optimizing SQL Statements"

• Chapter 10, "Using Plan Stability"