SQL Tuning
Publisher: O'Reilly Media
Released: November 2003
Pages: 338

A poorly performing database application not only costs users time, but also has an impact on other applications running on the same computer or the same network. SQL Tuning provides an essential next step for SQL developers and database administrators who want to extend their SQL tuning expertise and get the most from their database applications.

There are two basic issues to focus on when tuning SQL: how to find and interpret the execution plan of an SQL statement and how to change SQL to get a specific alternate execution plan. SQL Tuning provides answers to these questions and addresses a third issue that's even more important: how to find the optimal execution plan for the query to use.

Author Dan Tow outlines a timesaving method he's developed for finding the optimum execution plan--rapidly and systematically--regardless of the complexity of the SQL or the database platform being used. You'll learn how to understand and control SQL execution plans and how to diagram SQL queries to deduce the best execution plan for a query. Key chapters in the book include exercises to reinforce the concepts you've learned. SQL Tuning concludes by addressing special concerns and unique solutions to "unsolvable problems."

Whether you are a programmer who develops SQL-based applications or a database administrator or other who troubleshoots poorly tuned applications, SQL Tuning will arm you with a reliable and deterministic method for tuning your SQL queries to gain optimal performance.

Table of Contents
Product Details
About the Author
Colophon
Recommended for You
Customer Reviews

REVIEW SNAPSHOT®

by PowerReviews
oreillySQL Tuning
 
5.0

(based on 6 reviews)

Ratings Distribution

  • 5 Stars

     

    (6)

  • 4 Stars

     

    (0)

  • 3 Stars

     

    (0)

  • 2 Stars

     

    (0)

  • 1 Stars

     

    (0)

Reviewed by 6 customers

Sort by

Displaying reviews 1-6

Back to top

(1 of 1 customers found this review helpful)

 
5.0

Brilliant!

By Jack

from Undisclosed

Comments about oreilly SQL Tuning:

This book provides the ways and means to accomplish what so many others promise but don't deliver: a methodology to tune complex SQL joins.

It's a one trick pony, but it's a really, really good trick.

Applicable to any relational database product, carefully explained, exhaustively diagrammed and documented the technique Dan Tow has developed is a huge help to SQL tuning practitioners.

 
5.0

A must

By SQL

from Undisclosed

Comments about oreilly SQL Tuning:

This book is a must if you are working with SQL

Your first priority should be the design; if you have a good design then it is much easier to tune your DB. If your design is messed up then the next thing are the SQL statements. You will have to learn how to use the profiler and create appropriate indexes on your tables. This book will teach you how the tree structures behind the SQL work so that you will choose the appropriate joins and force index hints if necessary. I highly recommend this book for any SQL developer

SQL Server Code,Tips and Tricks, Performance Tuning (http://sqlservercode.blogspot.com/)

 
5.0

A Job Saver

By Fahd Mirza

from Undisclosed

Comments about oreilly SQL Tuning:

I was lost in the lybarinth of SQLs, they were performing badly and infested with every kind of waits and poor response times and awful costs and cards.

I was drowning and just blindly was putting an index here and a hint there, to no avail.

Then I got this book by Dan Tow and it really changed the way I lived my tuning life. DAN Diagrams not only made things optimal but also provided a common sense way to explain things to others. Dan's lucid explaination of esoteric concepts just made my life colorful. I highly recommend this book to anyone with a real flare to tune SQLs in the way they should be tuned and fixed.

Dan Diagrams Rock and Roll

 
5.0

Absolute needed book for a SQL tuning specialist - Highly recommended

By Ertugrul Bayindir

from Undisclosed

Comments about oreilly SQL Tuning:

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. Most of them giving information about facilities of the databases but not real life examples of how to use them. Now after reading this book I can tune SQL statements longer than 5 pages in length in just 2-3 hours. I did tuning for SQL statements having more than 20 tables in 2 hours. I am getting 4 to more than 10 times better run time performance regularly. I think this book turns black art of tuning to an engineering method.

I know it will be seem to like I am working for Oreilly but definetely not. I should also recommend another Oreilly book "Optimizing Oracle Performance" together with this book.

If you read both books I am sure you can do a great job.

For anyone interested, I created a small perl script which generates the tree like structures needed to tune SQL statements. It works on top of Business Objects repository(QM) to get the metadata needed. Therefore it is a BO only solution.

 
5.0

Great coverage, an essential reference

By Douglas Rowe from the Columbia Java Users Group

from Undisclosed

Comments about oreilly SQL Tuning:

If you are a DBA or developer, working daily with databases that support SQL, you need this book. It covers in better detail than any other book I've seen, all the behind the scenes aspects of SQL. What happens when you join, union or correlate queries? How do you know you're hitting your indexes? What new indexes do you need? Unlike most IT reference books, this one should be read cover to cover but it holds up well as a quick reference on a topic as well. Together with O'Reilly's SQL pocket guide by Jonathan Gennick, you have a formidable tool for creating and refining good SQL statements.

(1 of 1 customers found this review helpful)

 
5.0

SQL Tuning Review

By Brian Blades

from Undisclosed

Comments about oreilly SQL Tuning:

For many years the process of SQL Tuning has been considered an "art". SQL tuning books written to date have presented guidelines and "things to try" but "SQL Tuning" by Dan Tow is different. This is the first book I have seen that presents a clear methodology to attack the problem in a scientific/mathematical way and includes a diagramming technique to visualize the components of a query that affect performance. Dan's book has gone a long way in helping to transform SQL tuning from an art to a science.

The first four chapters of the book cover some of the subjects that are found in other SQL tuning books, and focus on the important points without delving too deeply into database internals. The really "good stuff" is covered in chapters 5 through 10, which includes how to "draw" a query diagram, and the procedures to follow to derive an optimal join order. The problems/examples presented and resolved in these chapters help the reader get a start on understanding the methodology, which can then be applied to actual tuning problems as they are encountered.

So far I have applied this technique to about 20 tuning problems I have encountered on the job using the Oracle RDBMS. I still consider myself a relative novice in using the methodology, but for each of the 20 problems I have been able to significantly reduce elapsed time and resource consumption (gets/reads). Also, these results were achieved in a matter or hours, rather than days. The query diagram has even facilitated finding "missing joins" in some of the queries without having a knowledge of the particular application.

This book is a "must have" for DBA's and developers and I highly recommend it.

Displaying reviews 1-6

Back to top

 
Buy 2 Get 1 Free Free Shipping Guarantee
Buying Options
Immediate Access - Go Digital what's this?
Ebook: $31.99
Formats:  APK, DAISY, ePub, Mobi, PDF
Print & Ebook: $43.95
Print: $39.95