Oracle High-Performance SQL Tuning / Edition 1

Oracle High-Performance SQL Tuning / Edition 1

by Donald Burleson, Donald K. Burleson
     
 

ISBN-10: 0072190582

ISBN-13: 9780072190588

Pub. Date: 07/27/2001

Publisher: McGraw-Hill Professional Publishing

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. You'll get details on Oracle's optimizer modes, SQL extensions, the STATSPACK utility, and a wealth of methods

…  See more details below

Overview

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. You'll get details on Oracle's optimizer modes, SQL extensions, the STATSPACK utility, and a wealth of methods for tuning Oracle SQL statements.

Product Details

ISBN-13:
9780072190588
Publisher:
McGraw-Hill Professional Publishing
Publication date:
07/27/2001
Series:
Oracle Press Series
Pages:
656
Product dimensions:
7.20(w) x 9.10(h) x 1.47(d)

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 Full-Table 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 Cost-Based Optimizer

15 Tuning with the Rule-Based 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 Built-in 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 Full-Table 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 Cost-Based Optimizer

15 Tuning with the Rule-Based 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 Built-in Functions and Special Operators

Read More

Customer Reviews

Average Review:

Write a Review

and post it to your social network

     

Most Helpful Customer Reviews

See all customer reviews >