Oracle SQL Tuning Pocket Reference

by Mark Gurry

One of the most important challenges faced by Oracle database administrators and Oracle developers is the need to tune SQL statements so that they execute efficiently. Poorly tuned SQL statements are one of the leading causes of substandard database performance and poor response time. SQL statements that perform poorly result in frustration for users, and can even prevent a company from serving its customers in a timely manner.

In this book, Mark...

• Format: Paperback
• Language: English
• ISBN: 0596002688
• ISBN13: 9780596002688
• Release Date: February 2002
• Publisher: O'Reilly Media
• Length: 108 Pages
• Weight: 0.26 lbs.
• Dimensions: 0.3" x 4.2" x 6.8"

Customer Reviews

Well written and to the point

I typically like these little pocket reference books from O'Reilly and this one is no exception. However, this is more than just a reference, it's a nice primer on Oracle SQL tuning. It's a pretty safe bet that you'll get your $10 worth out of this book pretty quickly.

Practical Oracle database tuning guide that provides best overall return

Purchased a few years ago, this little guide has provided the best return on investment when compared to more bulky works on the subject of Oracle database tuning. The word "reference" was probably chosen over the word "guide" in the title of this book because the former would seem to imply usage solely for quick lookups on various related subjects. However, this work is really a step-by-step primer that can be used alongside online Oracle database reference manuals. Because this book is so short, it can be digested in a matter of hours. During such a short time period, the reader is exposed to topics ranging from Oracle rules-based and cost-based optimization to database statistics gathering and SQL hints. And all this information is presented in a practical manner that includes many examples that will help the reader start off on the right path.

Essential guide for tuning Oracle SQL

This is the best book I've seen for tuning Oracle SQL.It is well written, up to date (includes 9i info), and full of examples and real world experiences. All packed into 100 little pages!Many of the Oracle books I've purchased (especially the tuning references) are just sitting on the shelf collecting dust. They're too big, and filled with a lot of 'dead weight'. I've already read this pocket reference twice (it's suprising how much more of it 'sticks' the second time around) and gathered more useful knowledge than all my other sql tuning books combined.I know this is called a pocket reference simply because of it's size, but it's really more of an instructional manual than just a reference.Every Oracle developer and DBA should read this book ...at least twice.

Worths to own one!

Yesterday, I saw this pocket book, then I decide to buy it because...* Clear clarification on which optimizer (cost-based and rule- based) is used for a specific situation and its problems.* Sorts, indexes, IN/EXISTS, OR/UNION, Loop, joins with tables...etc related performance issues and rating , giving a reader a reminder on the criteria to write a well-performed SQL.* What is bad SQL?How to use SQL Hints?* How to analyze table with DBMS_STATS package?* How to pre-define outline for your execution plan ?I have bought DBA checklist and Oracle with UNIX, they are my nice partners as well. Haha...I still remember I deal with a staging database problem in my work, I cannot find a solution from a THICK and HEAVY book but from them.If you need handy guides, pocket references are excellent and light, haha...I want to buy RMAN reference later :D, they seem a series of fiction.