Donald Burleson
McGraw-Hill Education
e druk, 2001
9780072190588
Oracle High-Performance SQL Tuning
Specificaties
Paperback, blz.
|
Engels
McGraw-Hill Education |
e druk, 2001
ISBN13: 9780072190588
Rubricering
Verwachte levertijd ongeveer 11 werkdagen
Samenvatting
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.
Specificaties
Inhoudsopgave
<H2> PART I Background<H3> 1 Introduction to SQL<H3> 2 Overview of Oracle SQL Extensions<H3> 3 Understanding SQL Execution<H3> 4 Overview of the SQL Optimizers<H3> 5 SQL Internal Processing<H3> 6 Tuning SQL Table Access<H2> PART II Basic SQL Tuning<H3> 7 The Steps to Oracle SQL Tuning<H3> 8 Understanding Oracle SQL Utilities<H3> 9 Locating Significant SQL Statements<H3> 10 Tuning Full-Table Scans and Parallel Query<H3> 11 Optimizing Sorting for Oracle SQL Statements<H3> 12 Tuning with Oracle Hints<H3> 13 Tuning with Optimizer Plan Stability<H3> 14 Tuning with the Cost-Based Optimizer<H3> 15 Tuning with the Rule-Based Optimizer<H3> 16 Tuning Table Joins<H2> PART III Advanced SQL Tuning<H3> 17 Tuning SQL DML Statements<H3> 18 Tuning SQL with Temporary Tables<H3> 19 Tuning SQL Subqueries<H3> 20 Tuning SQL with Indexes<H3> 21 Tuning Data Warehouse SQL<H3> 22 SQL Tuning with STATSPACK<H3> 23 Tuning SQL with Built-in Functions and Special OperatorsIndex<H2> PART I Background<H3> 1 Introduction to SQL<H3> 2 Overview of Oracle SQL Extensions<H3> 3 Understanding SQL Execution<H3> 4 Overview of the SQL Optimizers<H3> 5 SQL Internal Processing<H3> 6 Tuning SQL Table Access<H2> PART II Basic SQL Tuning<H3> 7 The Steps to Oracle SQL Tuning<H3> 8 Understanding Oracle SQL Utilities<H3> 9 Locating Significant SQL Statements<H3> 10 Tuning Full-Table Scans and Parallel Query<H3> 11 Optimizing Sorting for Oracle SQL Statements<H3> <$TSpAbove=165;>12 Tuning with Oracle Hints<H3> 13 Tuning with Optimizer Plan Stability<H3> 14 Tuning with the Cost-Based Optimizer<H3> 15 Tuning with the Rule-Based Optimizer<H3> 16 Tuning Table Joins<H2> PART III Advanced SQL Tuning<H3> 17 Tuning SQL DML Statements<H3> 18 Tuning SQL with Temporary Tables<H3> 19 Tuning SQL Subqueries<H3> 20 Tuning SQL with Indexes<H3> 21 Tuning Data Warehouse SQL<H3> 22 SQL Tuning with STATSPACK<H3> 23 Tuning SQL with Built-in Functions and Special Operators