|Amazon Price||New from||Used from|
Dan Tow is an independent consultant, operating under the banner SingingSQL (www.singingsql.com). His experience solving Oracle-related performance problems goes all the way back to his 1989 hire by Oracle Corporation. During most of his tenure at Oracle, Dan focused on the performance of Oracle Applications, managing the performance group for that division. In this role, he found a fertile testing ground for his SQL tuning method applied to the huge set of complex SQL included in those applications, including both online SQL and diverse batch processes. In 1998, Dan left Oracle to lead performance for TenFold Corporation, where he applied the same methods to tuning questions on DB2, and SQL Server, and Sybase, as well as on Oracle. In 2002, Dan started his own business, SingingSQL, through which he offers diverse database-related tuning services, including SQL tuning and systematically analyzing load to learn which SQL should be tuned. He has introduced his SQL tuning method to over 1,000 people in short lectures, and now offers in-depth courses in the material, using this book as textbook. Dan has a Ph.D. in chemical engineering from the University of Wisconsin at Madison. He lives in Palo Alto, California, and can be reached at firstname.lastname@example.org.
It's so far the only SQL tuning book I can recommend.
The method is highly algorithmic - you follow a series of fairly simple steps to draw a graph and out pops a near-optimal query plan.
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.
I hadn't had a chance to use this book as a practical guidance, but I enjoyed the clear and informative stile. Read morePublished 4 months ago by Dimitri K
1. funny, easy-to-understand method of tuning;
2. explanation of basic concepts.
1. the book is not easy to read. Read more
This is an OK book to get you started with SQL tuning. It is not an easy read. The explanations on reading
explain plan are not very clear and I feel the author could have... Read more
Like Dan, I have been doing Oracle for a long time (since 1984). I offer three opinions about Dan's book:
1) learning how to do query diagrams is great for people who... Read more
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. Read morePublished on January 9, 2007 by Dennis W. Willaims
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... Read morePublished on February 27, 2006 by Miracle
I was entangled in the web of horrible response time queries, not knowing what to do (except the darn hit ratios were maximum). Read morePublished on July 27, 2005 by Fahd Mirza
As a senior data warehousing specialist, I used several tools and books for tuning SQL so far and none of is giving the methodology needed. Read morePublished on May 17, 2005 by Bayindir Ertugrul