Publisher's Note: Products purchased from Third Party sellers are not guaranteed by the publisher for quality,authenticity, or access to any online entitlements included with the product.
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.
PART I Background1 Introduction to SQL2 Overview of Oracle SQL Extensions3 Understanding SQL Execution4 Overview of the SQL Optimizers5 SQL Internal Processing6 Tuning SQL Table AccessPART II Basic SQL Tuning7 The Steps to Oracle SQL Tuning8 Understanding Oracle SQL Utilities9 Locating Significant SQL Statements10 Tuning Full-Table Scans and Parallel Query11 Optimizing Sorting for Oracle SQL Statements12 Tuning with Oracle Hints13 Tuning with Optimizer Plan Stability14 Tuning with the Cost-Based Optimizer15 Tuning with the Rule-Based Optimizer16 Tuning Table JoinsPART III Advanced SQL Tuning17 Tuning SQL DML Statements18 Tuning SQL with Temporary Tables19 Tuning SQL Subqueries20 Tuning SQL with Indexes21 Tuning Data Warehouse SQL22 SQL Tuning with STATSPACK23 Tuning SQL with Built-in Functions and Special OperatorsIndexPART I Background1 Introduction to SQL2 Overview of Oracle SQL Extensions3 Understanding SQL Execution4 Overview of the SQL Optimizers5 SQL Internal Processing6 Tuning SQL Table AccessPART II Basic SQL Tuning7 The Steps to Oracle SQL Tuning8 Understanding Oracle SQL Utilities9 Locating Significant SQL Statements10 Tuninlcl
![Oracle High-Performance SQL Tuning [Paperback]](/itemImage/2/8/1/8/2_884425.jpg)