rent-now

Rent More, Save More! Use code: ECRENTAL

5% off 1 book, 7% off 2 books, 10% off 3+ books

9780072190588

Oracle High-Performance SQL Tuning

by
  • ISBN13:

    9780072190588

  • ISBN10:

    0072190582

  • Edition: 1st
  • Format: Paperback
  • Copyright: 2001-08-17
  • Publisher: McGraw-Hill Education
  • Purchase Benefits
  • Free Shipping Icon Free Shipping On Orders Over $35!
    Your order must be $35 or more to qualify for free economy shipping. Bulk sales, PO's, Marketplace items, eBooks and apparel do not qualify for this offer.
  • eCampus.com Logo Get Rewarded for Ordering Your Textbooks! Enroll Now
  • Write a Review Icon Write a Review
List Price: $63.00 Save up to $0.06
  • Buy New
    $62.94
    Add to Cart Free Shipping Icon Free Shipping

    USUALLY SHIPS IN 2-3 BUSINESS DAYS

Summary

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.

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

<$TSpAbove=165;>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

Supplemental Materials

What is included with this book?

The New copy of this book will include any supplemental materials advertised. Please check the title of the book to determine if it should include any access cards, study guides, lab manuals, CDs, etc.

The Used, Rental and eBook copies of this book are not guaranteed to include any supplemental materials. Typically, only the book itself is included. This is true even if the title states it includes any access cards, study guides, lab manuals, CDs, etc.

Rewards Program