+612 9045 4394
 
CHECKOUT
Oracle High-performance SQL Tuning : Oracle Press Series - Donald Keith Burleson

Oracle High-performance SQL Tuning

Oracle Press Series

Paperback

Published: 17th August 2001
Ships: 7 to 10 business days
7 to 10 business days
RRP $94.95
$91.95
or 4 easy payments of $22.99 with Learn more

SQL can greatly improve the performance of any Oracle database. This book shows the reader how to take any SQL statement, view the internal execution plan, and change the execution plan to improve the performance of the statement. This is a guide for all Oracle professionals who must maintain an Oracle database at optimal performance and write SQL statements. It covers a wealth of information for improving the performance of any SQL statement. The text will direct the reader through all of the SQL tuning steps and provide expert tips and techniques for tuning any type of SQL. The book takes the very complex and makes SQL tuning easy to comprehend. Technical tasks and SQL tuning steps are explained in a plain, easy-to-understand manner with an easy-to-follow methodology. Topics include: Oracle's optimiser modes and techniques for displaying the execution plan for SQL.

Background
Introduction to SQL
Overview of Oracle SQL Extensions
Understanding SQL Execution
Overview of the SQL Optimizers
SQL Internal Processing
Tuning SQL Table Access
Basic SQL Tuning
The Steps to Oracle SQL Tuning
Understanding Oracle SQL Utilities
Locating Significant SQL Statements
Tuning Full-Table Scans and Parallel Query
Optimizing Sorting for Oracle SQL Statements
Tuning with Oracle Hints
Tuning with Optimizer Plan Stability
Tuning with the Cost-Based Optimizer
Tuning with the Rule-Based Optimizer
Tuning Table Joins
Advanced SQL Tuning
Tuning SQL DML Statements
Tuning SQL with Temporary Tables
Tuning SQL Subqueries
Tuning SQL with Indexes
Tuning Data Warehouse SQL
SQL Tuning with STATSPACK
Tuning SQL with Built-in Functions and Special Operators Index
Background
Introduction to SQL
Overview of Oracle SQL Extensions
Understanding SQL Execution
Overview of the SQL Optimizers
SQL Internal Processing
Tuning SQL Table Access
Basic SQL Tuning
The Steps to Oracle SQL Tuning
Understanding Oracle SQL Utilities
Locating Significant SQL Statements
Tuning Full-Table Scans and Parallel Query
Optimizing Sorting for Oracle SQL Statements
Tuning with Oracle Hints
Tuning with Optimizer Plan Stability
Tuning with the Cost-Based Optimizer
Tuning with the Rule-Based Optimizer
Tuning Table Joins
Advanced SQL Tuning
Tuning SQL DML Statements
Tuning SQL with Temporary Tables
Tuning SQL Subqueries
Tuning SQL with Indexes
Tuning Data Warehouse SQL
SQL Tuning with STATSPACK
Tuning SQL with Built-in Functions and Special Operators
Table of Contents provided by Publisher. All Rights Reserved.

ISBN: 9780072190588
ISBN-10: 0072190582
Series: Oracle Press Series
Audience: Professional
Format: Paperback
Language: English
Number Of Pages: 656
Published: 17th August 2001
Publisher: McGraw-Hill Education - Europe
Country of Publication: US
Dimensions (cm): 23.0 x 19.0  x 3.8
Weight (kg): 1.0
Edition Number: 1