- Author:
- Donald K. Burleson
From the official Oracle Press comes a comprehensive guide to tuning SQL statements for optimal execution This expert resource explains how to view the internal execution plan of any SQL statement and change it to improve the performance of the statement Youll get details on Oracles optimizer modes SQL extensions the STATSPACK utility and a wealth of methods for tuning Oracle SQL statements Table of contents PART I Background 1 Introduction to SQL 2 Overview of Oracle SQL Extensions 3 Understanding SQL Execution 4 Overview of the SQL Optimizers 5 SQL Internal Processing 6 Tuning SQL Table Access PART II Basic SQL Tuning 7 The Steps to Oracle SQL Tuning 8 Understanding Oracle SQL Utilities 9 Locating Significant SQL Statements 10 Tuning FullTable Scans and Parallel Query 11 Optimizing Sorting for Oracle SQL Statements 12 Tuning with Oracle Hints 13 Tuning with Optimizer Plan Stability 14 Tuning with the CostBased Optimizer 15 Tuning with the RuleBased Optimizer 16 Tuning Table Joins PART III Advanced SQL Tuning 17 Tuning SQL DML Statements 18 Tuning SQL with Temporary Tables 19 Tuning SQL Subqueries 20 Tuning SQL with Indexes 21 Tuning Data Warehouse SQL 22 SQL Tuning with STATSPACK 23 Tuning SQL with Builtin Functions and Special OperatorsIndex PART I Background 1 Introduction to SQL 2 Overview of Oracle SQL Extensions 3 Understanding SQL Execution 4 Overview of the SQL Optimizers 5 SQL Internal Processing 6 Tuning SQL Table Access PART II Basic SQL Tuning 7 The Steps to Oracle SQL Tuning 8 Understanding Oracle SQL Utilities 9 Locating Significant SQL Statements 10 Tuning FullTable Scans and Parallel Query 11 Optimizing Sorting for Oracle SQL Statements TSpAbove16512 Tuning with Oracle Hints 13 Tuning with Optimizer Plan Stability 14 Tuning with the CostBased Optimizer 15 Tuning with the RuleBased Optimizer 16 Tuning Table Joins PART III Advanced SQL Tuning 17 Tuning SQL DML Statements 18 Tuning SQL with Temporary Tables 19 Tuning SQL Subqueries 20 Tuning SQL with Indexes 21 Tuning Data Warehouse SQL 22 SQL Tuning with STATSPACK 23 Tuning SQL with Builtin Functions and Special Operators