Oracle High-Performance SQL Tuning

Rating:
Summary: no detail and some mistake
Review: After having tuned our server, network, and database it was clear that the remaining slow performance was due to the SQL.
This led me to the purchase of this book which has not disapointed. This book goes into great detail about how sql statements effect database performance and how to correct it.
After just the first few chapters, I was able to quickly find 'hot' sql statements and see how they were causing bad performance due to full table scans, merge joins, slow index scans, hints, built in functions, sorting etc. This book gives a good explanation to the various table / index access methods and thus improved my ability to look at an explain plan and quickly see problem areas. With this book I have better understanding of the options to correct them without messing with the sql code. Infact, most all of these are correctable without changing the sql code - my favorite part.
There is of course a lot written on tuning to the code that can make great strides in performance as well, but as a dba and not a developer, I was more focused on things I could do to improve performance without changing the code.

The scrips with the book are especially good - pull sql out of the library cache on the fly, or out of statspack tables for hisorical analysis - and get reports on full table scans, various index scan reports, etc. These alone make the usefulness of this book fast and easy - worth it.

In short, I recomend this book to anyone wanting a better understanding of how sql code is affecting your DB performance as well as options to correct it. This is good if you have applications where you can't change the code (or just don't want to) but see improvements in performance need be made.

Rating:
Summary: This is a most excellent text
Review: I bought a copy of this book in hopes of tuning the SQL in my Oracle8i database and I was not disappointed. When using the techniques in the book, I was able to quickly identify and tune the most resource intensive SQL statements in my system. The book is clear and easy to understand.

Rating:
Summary: This is a most excellent text
Review: I bought a copy of this book in hopes of tuning the SQL in my Oracle8i database and I was not disappointed. When using the techniques in the book, I was able to quickly identify and tune the most resource intensive SQL statements in my system. The book is clear and easy to understand.

Rating:
Summary: Better than I expected
Review: I bought this book looking for a method to tune all of the SQL in an entire database. Much of the introductory material is self-evident, but the advanced topics are very insightful.

The text has lot's of examples, and clearly show how to find and fix sub-optimal SQL. Especially useful are the scripts to yank the SQL righ out of the library cache for analysis.

Some of the text moves very slowly, but this is expected for a comprehensive book on SQL tuning. This book explains many nuances of cost-based versus rule-based optimization, and the coverage of SQL hints is very good. Overall, this one is a keeper.

Rating:
Summary: Very helpful for optimizer tuning
Review: I found this book to be exceptionally helpful for tuning SQL at the optimizer level. I was happy to see that the text contains complete explainations of the optimizer modes and the benefits of each. I also liked the technique for analyzing SQL from the library cache, and I have found this book to be very helpful.

Rating:
Summary: Good book for tuning complex SQL
Review: I have a very complex system with lots of subqueries, and I was unable to find good tuning information until I tried the techniques in this book.

The book is simple to understand and explains the internals of complex Oracle SQL operations.

I have been very heppy with the results from my tuning, and I am thankful to find this textbook.

Rating:
Summary: An excellent & clear book about the sql internals
Review: It is an excellent book for those interested in the internals of sql. The knowledge of the author about the matter is excellent, and his style to write, clear, simple and funny.