| Welcome to vBulletin FAQ |
vBulletin FAQ Navigation
Getting Started
Customizing your vBulletin
Search Engines & SEO
Making Money with a Forum
Promoting your Community
|
| Get your own vBulletin Today |
|
| Webmaster Help |
|
|
|
SQL Tuning
vBulletin Book Store > vBulletin books beginning with S
|
SQL Tuning |
Author: Dan Tow
Published: 2003-12-01 |
List price: $39.95
Our price: $26.37
|
Usually ships in 24 hours
As of: December 04th, 2008 01:37:33 PM
|
|
|
Customer comments on this selection.
 Excellent resource for the Oracle DBA
Dan Tow has created a marvelous resource. With complex queries, it is often uncertain what is the best query plan. Dan Tow takes the mystery out of that process. He details a methodology that will give you the best query plan with a high degree of certainty. He also provides insights into how to achive the desired query plan.
A Work of Genius
I have withdrawn my earlier review because I did not properly understand the importance of this book until the second reading. That is a difficult admission to make since my business is database performance tuning.
br /
br /This book is about tuning SQL queries in a systematic and scientific manner. It is above all about determining the optimum order in which the query engine should access the tables involved. My quibble was that join order is only a part of the whole tuning problem and most of the time the query optimizer got it right anyway. While this is true, I see now that it misses the point.
br /
br /The fact that the optimizer gets it right so often allows us to take join order for granted. But how do we know the optimizer got it right unless we know what the optimum join order is? That is what this book teaches, a methodology and an elegant system of notation that allows us to determine the optimum join order of the most complex query. As the author points out, the number of possible join orders increases factorially with the number of tables involved. An 8 table join has 40,320 possible join orders. That rules out trial and error for all but the simplest queries.
br /
br /It turns out that analyzing and diagramming according to Tow's method gives you a deep architectural understanding of the query and the problems that face you. It gives you a plan to which you can apply the tools of the trade, indexes, code optimization, etc.
br /
br /This is a book that will be on the shelf of serious performance tuning professionals for as long as SQL is the language of data manipulation.
The first real SQL Tuning method.
I have worked with Oracle databases and SQL tuning since 1987, and the reason I recommend Dan's book so highly to anyone working with SQL is that his method is the first real method I've seen in this field. There are many approaches out there, but they all fall into the Guess Grimacing or Checklist categories. Dan's is a REAL method, and it works for all SQL-based databases. It's so far the only SQL tuning book I can recommend. Any DBA, developer and troubleshooter working with database-centric systems should know this stuff.
br /
br /Mogens
excellect condition
like new as described,fast shipment.
A Real Job Saver
I was entangled in the web of horrible response time queries, not knowing what to do (except the darn hit ratios were maximum). In utter frustration, I was putting an index here and dropping an index there, inserting a hint here and then setting a parameter there.
br /
br /Within 1 day of reading Mr. Dan Tow book, I was able to bring my biggest thorn query from 8 hours response time to just 10 minutes. Boy was I blissful. Certainly Dan Diagrams rock.
|
|
Our vBulletin book picks:
|
|
Find more vBulletin related products of interest.
|
