 |
Oracle High-Performance SQL Tuning | Donald K. Burleson
Oracle Press, Paperback, Published July 2001, 575 pages, ISBN 0072190582 | List Price: $49.99
Our Price: $30.50
You Save: $19.49 (39% Off)
| | | Availability: Out-Of-Stock |
Customer Reviews: 2 Average Customer Rating:  Write a Review and tell the world about this title! People who purchase this book frequently purchase: Books on similar topics, in best-seller order:Books from the same publisher, in best-seller order:
High demand--tuning books consistently rate among the
top 3 best-selling topics in the Oracle Press lineExpert coverage--explains
in detail how to improve database performance dramatically by tuning SQL statementsUrgent
need--acceptable e-commerce response time has dropped nearly 3 seconds in just
one year. This book provides techniques for minimizing response time. Huge reader
base--all Oracle professionals, from DBAs to developers, will need this book
BACK COVER
Improve Database Performance by Tuning SQL Statements
Tune all types of SQL statements--from a simple SELECT statement to a complex
non-correlated subquery--using tips and techniques from SQL expert Don Burleson.
Officially authorized by Oracle Corporation, this in-depth resource explains
how to take any SQL statement, view the internal execution plan, and change
the execution plan 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.
- Understand how SQL tuning fits into the overall Oracle tuning model
- Improve Oracle SQL functionality using extensions such as in-line views
and BIFs
- Identify and report on SQL in the library cache
- Tune SQL table access, full-table scans, and parallel query
- Run TKPROF to get a SQL trace report
- Change the execution plans for Oracle SQL statements using Oracle hints
- Use the Oracle8i optimizer plan stability, cost-based optimizer,
and rule-based optimizer
- Tune SQL DML statements, SQL subqueries, and data warehouse SQL
- Tune SQL with temporary tables and indexes
- Diagnose and optimize system performance using STATSPACK
CONTENTS
- Background
- 1: Introduction to SQL Tuning
- 2: Overview of the SQL Standard
- 3: Understanding the SQL Execution
- 4: Overview of the SQL Optimizers
- 5: The Interaction between SQL and the Database
- 6: The Interaction between SQL and Tables
-
- Basic SQL Tuning
- 7: The Steps of Oracle SQL Tuning
- 8: Understanding the Oracle SQL Utilities
- 9: Finding Significant SQL Statements
- 10: Tuning Full-Table Scans
- 11: Optimizing Sorting for Oracle SQL
- 12: Tuning with Oracle Hints
- 13: Tuning with Optimizer Plan Stability
- 14: Tuning with Cost-Based Optimizer
- 15: Tuning with the Rule-Based Optimizer
- 16: Tuning Joins
-
- Advanced SQL Tuning
- 17: Tuning SQL DML Statements
- 18: Tuning SQL with Temporary Tables
- 19: Tuning Subqueries
- 20: Tuning with Indexes
- 21: Tuning Data Warehouse SQL
- 22: SQL Tuning with STATSPACK
- 23: Tuning SQL with Built-in Function
Customer Reviews
Customer Reviews: 2 Average Customer Rating: May 7, 2002 Som Vembar (somvembar@yahoo.com) from Toronto, Canada
Best book on Oracle SQL Tuning
After having gone through many books and gained little, I picked up this book. In the last 3 weeks after I started reading this one, I feel that I am on the right track into the complex world of SQL Tuning.
Most of the other tuning books blindly tell us what to do. But this one gives, along with the basic knowledge, the insight into how Oracle thinks and acts, which provokes our thinking capacity, which is so very essential while tuning.
Probably, the best book on SQL tuning.
Jan 1, 2002 Dale Martin from Fairport, NY
Best Oracle SQL tuning book
This is the best comprehensive Oracle SQL tuning book that is on the market. The text is full of useful scripts, and the author gives many tricks for quickly locating and tuning offensive SQL statements.
|
|
