Title and Copyright Information


Changes in This Release for Oracle Database SQL Tuning Guide

Part I SQL Performance Fundamentals

1 Introduction to SQL Tuning

2 SQL Performance Methodology

Part II Query Optimizer Fundamentals

3 SQL Processing

4 Query Optimizer Concepts

5 Query Transformations

Part III Query Execution Plans

6 Generating and Displaying Execution Plans

7 Reading Execution Plans

Part IV SQL Operators: Access Paths and Joins

8 Optimizer Access Paths

9 Joins

Part V Optimizer Statistics

10 Optimizer Statistics Concepts

11 Histograms

12 Managing Optimizer Statistics: Basic Topics

13 Managing Optimizer Statistics: Advanced Topics

Part VI Optimizer Controls

14 Influencing the Optimizer

15 Improving Real-World Performance Through Cursor Sharing

Part VII Monitoring and Tracing SQL

16 Monitoring Database Operations

17 Gathering Diagnostic Data with SQL Test Case Builder

18 Performing Application Tracing

Part VIII Automatic SQL Tuning

19 Managing SQL Tuning Sets

20 Analyzing SQL with SQL Tuning Advisor

21 Optimizing Access Paths with SQL Access Advisor

Part IX SQL Controls

22 Managing SQL Profiles

23 Managing SQL Plan Baselines

24 Migrating Stored Outlines to SQL Plan Baselines

A Guidelines for Indexes and Table Clusters