SQL Tuning

SQL Tuning
ISBN-10
0596005733
ISBN-13
9780596005733
Category
Computers / Languages / SQL
Pages
314
Language
English
Published
2004
Publisher
O'Reilly Media
Author
Dan Tow

Description

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.

Get the book

Amazon.com
Amazon.com
Search the book
eBay.com
eBay.com
Search the book

Other editions

Similar books

  • Inside Microsoft SQL Server 2008: T-SQL Querying
    Inside Microsoft SQL Server 2008: T-SQL Querying
    By Itzik Ben-Gan

    Tackle the toughest set-based querying and query tuning problems--guided by an author team with in-depth, inside knowledge of T-SQL. Deepen your understanding of architecture and internals--and gain practical approaches and...

  • Inside Microsoft SQL Server 2008: T-SQL Programming
    Inside Microsoft SQL Server 2008: T-SQL Programming
    By Itzik Ben-Gan

    Get a detailed look at the internal architecture of T-SQL with this comprehensive programming reference. Database developers and administrators get best practices, expert techniques, and code samples to master the...

  • Advanced Oracle PL/SQL: Programming with Packages
    Advanced Oracle PL/SQL: Programming with Packages
    By Steven Feuerstein

    Steven Feuerstein's first book,Oracle PL/SQL Programming, has become the classic reference to PL/SQL, Oracle's procedural extension to its SQL language. His new book looks thoroughly at one especially advanced and...

  • Inside Microsoft SQL Server 2005: Query Tuning and Optimization
    Inside Microsoft SQL Server 2005: Query Tuning and Optimization
    By Kalen Delaney

    Dig into the internals of tuning and optimization features in SQL Server 2005--with insights from leading SQL Server experts. This in-depth guide delivers best practices, pragmatic advice, and code samples...

  • A Developer's Guide to SQL Server 2005
    A Developer's Guide to SQL Server 2005
    By Bob Beauchemin, Dan Sullivan

    "I come from a T-SQL background, so when I first laid my eyes on SQL Server 2005, I was shocked--and then, I was scared! I didn't have a CLR or...

  • SQL Fundamentals
    SQL Fundamentals
    By John J. Patrick

    A comprehensive tutorial covering the fundamental concepts and ideas of SQL, and showing how these are implemented in both Oracle 9I and Access 2000 databases. John Patrick discusses how to...

  • Microsoft SQL Server 7.0 Programming Unleashed
    Microsoft SQL Server 7.0 Programming Unleashed
    By Matthew Shepker, John Papa

    Certified professionals offer the benefits of their experiences in a variety of SQL Server settings as well as useful tips and workarounds to common problems. Overview of Major Topics: Part...

  • A First Look at SQL Server 2005 for Developers
    A First Look at SQL Server 2005 for Developers
    By Bob Beauchemin, Dan Sullivan, Niels Berglund

    Be the first to master SQL Server 2005's breakthrough database development capabilities Few technologies have been as eagerly anticipated as Microsoft SQL Server 2005 ("Yukon"). Now, three SQL Server insiders...

  • Real World SQL Server Administration with Perl
    Real World SQL Server Administration with Perl
    By Linchi Shea

    This book is about solving SQL Server administrative problems with Perl. Linchi has designed it to consist of a series of scenarios covering a wide range of SQL Server administrative...

  • A Guide to the SQL Standard: A User's Guide to the Standard Relational Language SQL
    A Guide to the SQL Standard: A User's Guide to the Standard Relational Language SQL
    By C. J. Date, Hugh Darwen

    A guide for users and designers of database systems. Outlines the inherent problems in the study, design, and implementation, and examines the background issues of priorities, administrative prerequisites, design concepts,...