Average Customer Review:
 ( 10 customer reviews )
Write an online review and share your thoughts with other customers.
Most Helpful Customer Reviews
7 of 7 found the following review helpful:
 Ancient coverageFeb 06, 2006
By Lorraine de DBA
I'm sure that this was a great book in it's day, but it is 5 years old and useful only for firewood. The rule optimizer is not even there anymore. [...]
7 of 10 found the following review helpful:
 Great book for deeper understanding of sql performanceSep 07, 2001
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.
10 of 15 found the following review helpful:
no detail and some mistakeSep 20, 2001
The book never go deep into sql even the author promised to do so, it is not a step-by-step guild that dbas can follow, and the seasoned dba also do not need this book because of nothing new.
You can see some obvious mistake in this book, for example, about the hash join, Mr. Burleson told us in the page 67 and page 391 that the hash table probe the large table, but oracle document said large table probes the hash table. I hope to see some detail about the analyse of execution plan of table join and scenario, but there is none.
Very good book about performance tuningMar 24, 2009
By Ivan Chestaro
Although a little outdated, this book is very valuable in what its sells: performance SQL tuning. It explains clearly with a lot of examples and very helpful hints. If you are trying to get to know how to tune SQL queries, get this book.
Good stuff!Aug 09, 2007
By R. Biggs
"nonfiction fan"
Still working my way through it, but have already gleaned several insights from it. This gives me information I had not yet found in Oracle manuals. (I'm an application developer, trying to work productively with database administrators and system administrators.)
See all 10 customer reviews on Amazon.com
|
based on 10 reviews
