Rating:  Summary: Informative and actually INTERESTING!!! Review: A great book for beginners or advanced Oracle users. It really provides a wider array of information than just tuning- from logical structuring of the data to a review of basic SQL to advanced tuning concepts. Information is provided in short bursts, making it very readable and easy to "digest". About as "breezy" as a technical book can get.
Rating:  Summary: Oracle DBA's and developers must have this book. Review: Absolutly this is the best book about SQL tuning I have had. This is essential for the Oracle developers to know how to optimize the applications. Although Harrison says this is not a book for the DBA's, I think this is a "must has book" for the DBA's too. I use this book as reference to optimize the code of the applications and to know about the best optimization.Excellent work in this book. Thanks Mr. Harrison.
Rating:  Summary: Very good book for your first and foremost tuning book Review: Easy to read, concise,useful information. Except for some typos (which are rather blatant when they occur) and a limited index (in this age of word processor generated indexes, no less) this book would deserve 5 stars. Will quickly bring up an intermediate programmer up to speed so that not only will his/her code run...it will run well!
Rating:  Summary: Excellent Oracle SQL & PL/SQL tuning book Review: Except for some missing hints (pg. 57-59) and some mixed up hint syntax, I found the book accurate and very enlightening. I've now used it on two from-scratch VLDB projects. Almost every page has something I was able to use to refine SQL statements & PL/SQL server-side code. For example, pg. 206, the section on MAX & MIN statements was the key to my latest project being able to process 20X the number of records we currently do. The section on learning to read tkprof output was helpful. The bibliography was also great (but is probably outdated now). Worth every penny!
Rating:  Summary: Excellent book Review: Except for some typos, this is a very good Oracle SQL tuning book. Even the Appendix F is useful. I recommend it to Oracle SQL developers and Oracle DBAs.
Rating:  Summary: The best Oracle SQL Tuning book available Review: I do a lot of SQL tuning for Oracle. This book is the best book I have read in this subject. It is not bias, it is clear, easy to understand, with good practical examples. It is written for a truly expert in Oracle SQL tuning. Using plain english the author explains a lot of concepts that are fundamental for a successful SQL tuning effort. I read the 1st edition more than once, and I am reading the 2nd edition for the second time. If you already have the first edition, it is worth to purchase the second edition that has been updated and feeded with additional elements. If you only have the time to read one book in Oracle SQL tuning, this is your book.
Rating:  Summary: The best Oracle SQL Tuning book available Review: I do a lot of SQL tuning for Oracle. This book is the best book I have read in this subject. It is not bias, it is clear, easy to understand, with good practical examples. It is written for a truly expert in Oracle SQL tuning. Using plain english the author explains a lot of concepts that are fundamental for a successful SQL tuning effort. I read the 1st edition more than once, and I am reading the 2nd edition for the second time. If you already have the first edition, it is worth to purchase the second edition that has been updated and feeded with additional elements. If you only have the time to read one book in Oracle SQL tuning, this is your book.
Rating:  Summary: Great tuning book Review: I had a nagging and peculiar performance problem with a specific query involving a quirk in the Oracle optimizer which I had been trying to solve on and off for months. With the help of this book, I resolved the problem. It has a level of detail in query optimization way beyond other "highly recommended" books. The explanations are clear, *complete* (completeness was lacking in the other books), and easy and enjoyable to read. I finally have the understanding of these Oracle internals that I have been seeking!
Rating:  Summary: There is no other book on SQL Tuning Review: I have read this book cover to cover and more. I have been using this book since 1998 and I still have to say it is good book.It is one of the Oracle Classics. It is a little outdated. If you look at the cover it clearly states it covers to oracle 8i. If you still have 8i databases this is a good book. if you are using 9i and cost based optimization it is still useful but it will not pick up on some of the newer fetures of the CBO. If you use Rule based optimization(RBO) than it is a good book. I had actually used this book as a teaching guide when I use to teach SQL Tuning for an application software company who uses oracle database. I look forward to when the revised version does ship.
Rating:  Summary: Great book Review: I love this book. Highly readable, it makes previously hard-to-grasp concepts, such as rule vs. cost-based optimization, tuning hints, etc, finally comprehensible. I've only started reading, but so far I have been able to assemble many months worth of garbled concepts and half-understandings into a much more cohesive unit of knowledge. Of all my books that discuss SQL tuning, this one is the best by far. Thank you Guy Harrison!
|