Order from a Major Online Bookstore
Ultimate Book Price Comparison Engine
Save Your Time And Money
| AnyBook4Less.com | Order from a Major Online Bookstore |
|
| Home | Store List | FAQ | Contact Us | | ||
| Ultimate Book Price Comparison Engine Save Your Time And Money |
||
 |
Title: Oracle SQL High-Performance Tuning (2nd Edition) by Guy Harrison ISBN: 0-13-012381-1 Publisher: Prentice Hall PTR Pub. Date: 29 December, 2000 Format: Paperback Volumes: 1 List Price(USD): $54.99 |
Average Customer Rating: 4.48 (23 reviews)
Rating: 3
Summary: Useful, but flawed
Comment: Of all the SQL tuning books available on the market, this one provides the most depth. It provides solid, easy to follow examples. The flaw in this book is that it just provides 'techniques' for improving performance. It's basically a book that is useful for trial and error SQL tuning.
When tuning SQL you should think in terms of sets and essentially 'What can I do to make the optimizer do the least work?' This book does not teach you to do that. I've yet to see one book that does. It also only discusses response time. Response time is an ends and is not a means in SQL tuning. By reducing the amount of work Oracle has to do, you improve response time.
There is one serious inaccuracy in this book. I emailed the author about this and he did not respond. The author states that you can improve response time of updates, by wrapping them inside of a PL/SQL cursor. This is not only inaccurate, it's not even close. Not only does it take twice as long in Oracle 8i(slightly less in 9i), but it also increases logical I/Os significantly. How something this inaccurate could be missed in a major publication astounds me. To be fair, the 8i version of Steven Fuersteins PL/SQL book has the same inaccuracy(I have not read the 9i version).
The rest of the book seems accurate. I recommend it, but beware that inaccuracy. I have not tested everything the author has stated, but I have not found any other inaccuracies.
Rating: 5
Summary: The best Oracle SQL tuning book!
Comment: I've been tuning Oracle Applications instances for several customers, this book is the best in its class. It is easy to read, it follows a logical path. I always use it as my main reference book for SQL tuning. If you want to increase your knowledge in Oracle SQL tuning, this is the book. It provides good examples and explains concepts very well.
Rating: 5
Summary: There is no other book on SQL Tuning
Comment: 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.
 |
Title: Oracle SQL Tuning Pocket Reference by Mark Gurry ISBN: 0596002688 Publisher: O'Reilly & Associates Pub. Date: 15 November, 2001 List Price(USD): $12.95 |
 |
Title: Expert One-on-One Oracle by Thomas Kyte ISBN: 1590592433 Publisher: APress Pub. Date: 08 August, 2003 List Price(USD): $59.99 |
 |
Title: Effective Oracle by Design (Osborne ORACLE Press Series) by Thomas Kyte ISBN: 0072230657 Publisher: McGraw-Hill Osborne Media Pub. Date: 21 August, 2003 List Price(USD): $59.99 |
 |
Title: Oracle High-Performance SQL Tuning by Donald K. Burleson ISBN: 0072190582 Publisher: McGraw-Hill Osborne Media Pub. Date: 27 July, 2001 List Price(USD): $49.99 |
 |
Title: Optimizing Oracle Performance by Cary Millsap ISBN: 059600527X Publisher: O'Reilly & Associates Pub. Date: 15 September, 2003 List Price(USD): $34.95 |
Thank you for visiting www.AnyBook4Less.com and enjoy your savings!
Copyright� 2001-2021 Send your comments
