Database Journal
MS SQL Oracle DB2 Access MySQL PostgreSQL Sybase PHP SQL Etc SQL Scripts & Samples Tips Database Forum Rss Feed

» Database Journal Home
» Database Articles
» Database Tutorials
MS Access
SQL Scripts & Samples
» Database Forum
» Slideshows
Free Newsletters:

News Via RSS Feed

Rss Feed

Database Journal |DBA Support |SQLCourse |SQLCourse2

Featured Database Articles

Database News

Posted Nov 26, 2003

"SQL Tuning": The No-Guesswork Method for Generating Optimal Execution Plans

By DatabaseJournal.com Staff

[From O'Reilly & Associates, Inc.]

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."

The article continues at http://press.oreilly.com/pub/pr/1123

Buy this book
"SQL Tuning": The No-Guesswork Method for Generating Optimal Execution Plans

O'Reilly & Associates, Inc.

Database News Archives

Latest Forum Threads
Database News Forum
Topic By Replies Updated
Efficient SQL Server Indexing by Design lcole 0 April 30th, 12:38 PM
Mine Oracle Database, SQL Server and Other Databases with Monarch Data Pump Pro V10.5 lcole 0 April 30th, 12:37 PM
Oracle Database and Oracle Fusion Middleware for Private Social Network Application lcole 0 April 30th, 12:31 PM
Oracle Database Maintains a Stronghold in the DBMS Market lcole 0 April 30th, 12:30 PM