Recent SCO/Linux News

From: Kathryn Barrett <kathrynb@oreilly.com>
Subject: "SQL Tuning" Released by O'Reilly
Date: Mon, 24 Nov 2003 20:26:24 GMT

The No-Guesswork Method for Generating Optimal Execution Plans
O'Reilly Releases "SQL Tuning"
        
Sebastopol, CA--Early on, Dan Tow, author of the just-released "SQL
Tuning" (O'Reilly, US $39.95) realized that the biggest factor in the
performance of a business application is the speed of the SQL it runs. It
took him a little longer to realize just how much room for improvement
typically lies in that SQL--in fact, that the SQL that most affects the
load on a system and the productivity of its end users can usually be
improved by a large factor, often by a factor of two or more. The problem
was finding reliable guidance on just how to tune SQL.

There are two basic issues that most people 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.  Tow provides the
answers to these questions in "SQL Tuning" and addresses a third, even
more critical question: How do you decide which execution plan a query
should use?

The process involved is usually one of frustrating trial and error. As Tow
explains, "Since real business-application queries can easily offer
billions of alternative execution plans, tuning without a systematic
method to choose your target execution plan is hopelessly inefficient. The
problem is akin to finding yourself lost in strange city without a map:
working eyes and legs are not enough to take you where you need to go."

"SQL Tuning" details a diagram-based method for tuning SQL statements. The
method is not iterative and random, but deterministic: you follow a
well-defined process once, and at the end of that process you will know
the optimal execution plan for the statement in question.  The method
involved not only leads you to an optimal plan quickly and in one pass,
but also assures you that it is, indeed, the optimal plan. This last point
is important because you'll know when to stop spending time trying to
improve the execution of a SQL statement and seek improvement through
other means, such as changes to indexes, the database design, or the
application using the SQL.

"Dan doesn't guess," writes Jonathan Gennick in his foreword to the book.
"He doesn't execute an iterative guess-loop, trying one idea after another
in the hope of stumbling across an improvement. Instead, Dan uses an
innovative and mathematically based diagramming method to derive the
optimal, or near-optimal, execution plan for a SQL statement. Then he puts
that plan into effect. And that's it. There's no guesswork, and there's no
uncertainly as to whether further improvement is possible."

Written for readers who already know SQL and have an opportunity to tune
SQL or the database where the SQL executes, "SQL Tuning" includes specific
techniques for tuning on Oracle, Microsoft SQL Server, and IBM DB2.  But
since the book focuses on finding the optimum path to the data--which,
according to Tow, is virtually independent of the database vendor--most of
the book covers a vendor-independent solution to the problem.

The perfect companion to O'Reilly's "SQL in a Nutshell," this book will
arm anyone who troubleshoots poorly tuned applications with a reliable and
deterministic method for tuning their SQL queries.

Additional Resources:

Chapter 1, "Introduction," is available free online at:
http://www.oreilly.com/catalog/sqltuning/chapter/index.html

For more information about the book, including Table of Contents, index,
author bio, and samples, see:
http://www.oreilly.com/catalog/sqltuning/

For a cover graphic in JPEG format, go to:
ftp://ftp.ora.com/pub/graphics/book_covers/hi-res/0596005733.jpg

SQL Tuning
Dan Tow
ISBN 0-596-00573-3, 314 pages, $39.95 US, $61.95 CA
order@oreilly.com
1-800-998-9938
1-707-827-7000
http://www.oreilly.com

About O'Reilly
O'Reilly & Associates is the premier information source for leading-edge
computer technologies. The company's books, conferences, and web sites
bring to light the knowledge of technology innovators. O'Reilly books,
known for the animals on their covers, occupy a treasured place on the
shelves of the developers building the next generation of software.
O'Reilly conferences and summits bring alpha geeks and forward-thinking
business leaders together to shape the revolutionary ideas that spark new
industries. From the Internet to XML, open source, .NET, Java, and web
services, O'Reilly puts technologies on the map. For more information:
http://www.oreilly.com

# # #

O'Reilly is a registered trademark of O'Reilly & Associates, Inc. All
other trademarks are property of their respective owners.

Index

My Unix/Linux Troubleshooting Book

My Hard Truths about Easy Money Book

My Self Employment Book

Jump to Comments

Many of the products and books I review are things I purchased for my own use. Some were given to me specifically for the purpose of reviewing them. I resell or can earn commissions from the sale of some of these items. Links within these pages may be affiliate links that pay me for referring you to them. That's mostly insignificant amounts of money; whenever it is not I have made my relationship plain. I also may own stock in companies mentioned here. If you have any question, please do feel free to contact me.

Specific links that take you to pages that allow you to purchase the item I reviewed are very likely to pay me a commission. Many of the books I review were given to me by the publishers specifically for the purpose of writing a review. These gifts and referral fees do not affect my opinions; I often give bad reviews anyway.

We use Google third-party advertising companies to serve ads when you visit our website. These companies may use information (not including your name, address, email address, or telephone number) about your visits to this and other websites in order to provide advertisements about goods and services of interest to you. If you would like more information about this practice and to know your choices about not having this information used by these companies, click here.