Join Amazon Prime and ship Two-Day for free and Overnight for $3.99. Already a member? Sign in.

 

or
Sign in to turn on 1-Click ordering.
 
 
More Buying Choices
31 used & new from $19.99

Have one to sell? Sell yours here
 
   
SQL Performance Tuning
 
 
Tell the Publisher!
I’d like to read this book on Kindle

Don’t have a Kindle? Get yours here.
 
  

SQL Performance Tuning (Paperback)

by Peter Gulutzan (Author), Trudy Pelzer (Author)
4.6 out of 5 stars See all reviews (10 customer reviews)

List Price: $54.99
Price: $40.14 & this item ships for FREE with Super Saver Shipping. Details
You Save: $14.85 (27%)
o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o
In Stock.
Ships from and sold by Amazon.com. Gift-wrap available.

Only 3 left in stock--order soon (more on the way).

Want it delivered Monday, July 20? Choose One-Day Shipping at checkout. Details
16 new from $29.00 15 used from $19.99

Frequently Bought Together

SQL Performance Tuning + SQL Tuning + The Art of SQL
Price For All Three: $96.20

Show availability and shipping details

  • This item: SQL Performance Tuning by Peter Gulutzan

    In Stock.
    Ships from and sold by Amazon.com.
    This item ships for FREE with Super Saver Shipping. Details

  • SQL Tuning by Dan Tow

    In Stock.
    Ships from and sold by Amazon.com.
    This item ships for FREE with Super Saver Shipping. Details

  • The Art of SQL by Stephane Faroult

    In Stock.
    Ships from and sold by Amazon.com.
    This item ships for FREE with Super Saver Shipping. Details


Customers Who Bought This Item Also Bought

The Art of SQL

The Art of SQL

by Stephane Faroult
4.7 out of 5 stars (18)  $29.69
SQL Cookbook (Cookbooks (O'Reilly))

SQL Cookbook (Cookbooks (O'Reilly))

by Anthony Molinaro
4.7 out of 5 stars (44)  $26.37
Joe Celko's SQL for Smarties: Advanced SQL Programming Third Edition (The Morgan Kaufmann Series in Data Management Systems)

Joe Celko's SQL for Smarties: Advanced SQL Programming Third Edition (The Morgan Kaufmann Series in Data Management Systems)

by Joe Celko
4.1 out of 5 stars (49)  $38.40
MySQL Stored Procedure Programming

MySQL Stored Procedure Programming

by Guy Harrison
4.5 out of 5 stars (11)  $29.69
High Performance MySQL: Optimization, Backups, Replication, and More

High Performance MySQL: Optimization, Backups, Replication, and More

by Baron Schwartz
4.6 out of 5 stars (17)  $31.49
Explore similar items

Editorial Reviews

Product Description
A poorly performing database application can cost each user time, and have an impact on other applications running on the same computer or the same network. This book will help DBA's and programmers improve the performance of their databases. It is not an introduction to SQL, nor is it a tuning manual for a particular SQL implementation. It is a guide for users and programmers who want to improve SQL performance no matter what brand of SQL they use. It will provide tuning tips for common situations, such as how to change a query so it will go faster and how to shift work from the server to the client. All the ideas have been tested against the eight leading DBMS applications. Almost all large organizations and companies today run more than one type of database. This is the only book to cover database tuning for them.

From the Back Cover

SQL Performance Tuning is a handbook of practical solutions for busy database professionals charged with managing an organization's critically important data. Covering today's most popular and widely installed database environments, this book is an indispensable resource for managing and tuning SQL across multiple platforms.

Packed with tips, techniques, and best practices, this hands-on guide covers SQL commands and queries over a wide range of conditions and environments. Every facet of the SQL environment is covered, from concurrency control to optimization—and every issue in between. The book includes an overview of each of the most widely used database management systems (DBMS) and provides tuning tips for common day-to-day situations.

Topics covered include:

  • General and specific tuning
  • General sort considerations and options
  • Joins and subqueries
  • Columns and tables
  • Indexes, including B-trees and bitmaps
  • Constraints and stored procedures
  • ODBC and JDBC
  • Data changes and concurrency control (locking)
  • Clients, servers, and middleware
  • Whether you are a programmer, consultant, or user, you will find SQL Performance Tuning an indispensable guide to optimizing SQL performance across today's popular database environments.

    Throughout SQL Performance Tuning, ideas and techniques are tested on a variety of popular SQL environments, including IBM DB2, Informix, Ingres, InterBase, Microsoft SQL Server, MySQL, Oracle, and Sybase ASE. The book's practical examples are written in ANSI/ISO Standard SQL: 1999.



    0201791692B08082002

    See all Editorial Reviews

    Product Details

    • Paperback: 528 pages
    • Publisher: Addison-Wesley Professional (September 20, 2002)
    • Language: English
    • ISBN-10: 0201791692
    • ISBN-13: 978-0201791693
    • Product Dimensions: 9.2 x 7.2 x 1.1 inches
    • Shipping Weight: 1.8 pounds (View shipping rates and policies)
    • Average Customer Review: 4.6 out of 5 stars See all reviews (10 customer reviews)
    • Amazon.com Sales Rank: #772,622 in Books (See Bestsellers in Books)

    Look Inside This Book

    What Do Customers Ultimately Buy After Viewing This Item?

    SQL Performance Tuning
    45% buy the item featured on this page:
    SQL Performance Tuning 4.6 out of 5 stars (10)
    $40.14
    SQL Tuning
    32% buy
    SQL Tuning 4.7 out of 5 stars (15)
    $26.37
    Oracle SQL Tuning Pocket Reference
    10% buy
    Oracle SQL Tuning Pocket Reference 5.0 out of 5 stars (4)
    $9.95
    The Art of SQL
    7% buy
    The Art of SQL 4.7 out of 5 stars (18)
    $29.69

    Tags Customers Associate with This Product

     (What's this?)
    Click on a tag to find related items, discussions, and people.
    Check the boxes next to the tags you consider relevant or enter your own tags in the field below.
    (3)

    Your tags: Add your first tag
     
    Help others find this product — tag it for Amazon search
    No one has tagged this product for Amazon search yet. Why not be the first to suggest a search for which it should appear?

    Sell a Digital Version of This Book in the Kindle Store

    If you are a publisher or author and hold the digital rights to a book, you can sell a digital version of it in our Kindle Store. Learn more

     

    Customer Reviews

    10 Reviews
    5 star:
     (8)
    4 star:    (0)
    3 star:
     (2)
    2 star:    (0)
    1 star:    (0)
     
     
     
     
     
    Average Customer Review
    4.6 out of 5 stars (10 customer reviews)
     
     
     
     
    Share your thoughts with other customers:
    Most Helpful Customer Reviews

     
    13 of 13 people found the following review helpful:
    3.0 out of 5 stars READERS GAIN: 3/8, January 26, 2006
    By Dmitry Dvoinikov (Ekaterinburg, Russia) - See all my reviews
    This book is rather controversial. I'll begin with a quote from the preface:

    QUOTE
    ...we've written it for users and programmers who want to improve SQL performance, no matter what brand of SQL they use. In this book, you'll find tuning tips for common situations... Rather than exploiting the unique features of a single DBMS, we're going to give you ideas that are good for all of the major SQL DBMSs.
    END QUOTE

    Sounds good, but !

    The biggest idea behind this book is that the authors took 8 most common databases (as per 2002: DB2, Informix, Ingres, Interbase, MS SQL, MySQL, Oracle, Sybase) and sort of compared them on many different subjects. I said "sort of" because you won't find specific recommendations like "DB2 does this better", or "this makes the query faster on Oracle". Instead, the authors came up with this idea - upon each discussed topic they summarize the gain that you might possibly get from using that particular technique should you be using it on _all_ of the 8 databases. They put it like:

    GAIN: x/8

    which means that with the discussed trick in place, x out of 8 databases performed better (and the rest showed no improvement).

    Two things make it break - (1) there is only so many tricks that improve on most databases (it's commonly 3/8) and (2) there is no way to tell which of 8 showed an improvement.

    And so, how does it help me as a database administrator and developer ? I only work with 2, may be 3 specific database servers and there is no way to tell whether _they_ gained from that trick or not. All I can do is to keep all tricks in mind, apply them all anyway and hope it was my database that had an improvement. Or, I can re-run tests and see for myself.

    The word about tests - the authors did run all the tests on the same single CPU Windows NT machine and specifically say:
    QUOTE
    We should explain that all timing tests for this book were done with a single-CPU computer, so comparisons between DBMSs would be misleading. The results wouldn't give full points to the DBMS with the best threading mechanisms.
    END QUOTE

    This book would make a good source for trivia questions. Tricks and tips all around, but many discussions are too short to be of any use and end up with catch-it-all rules.

    Examples:

    Chapter 17: Cost-based optimizers:
    About 10 pages. Says that cost-based and rule-based optimizers are different and CBO peform better because they use real statistics. And so you should update statistics and use EXPLAIN and optimizer hints. That's all. Oh no, really ?

    Chapter 11. Stored procedures.
    Shows very reasonably and truthfully why SPs are useful and better in many situation and what the gotchas are. But then again
    QUOTE
    When parameter passing is by value, the DBMS usually makes a local copy ... That leads inevitably to the bad idea of declaring parameters to be "input/output" even when they're merely "input" parameters. The trick ... is that an "input/output" parameter value is not recopied down the line if stored procedure #1 calls stored procedure #2 ... it saves you space and copying time.
    END QUOTE
    Bad be the idea or not, passing large amounts on a stack is certainly wrong, not only for SPs and indicates poor design. Otherwise, if you are passing small arguments, and want to optimize out the copying of a single int or varchar - what kind of a system is that ? I mean - you are calling an SP in a database. It begins a transaction, processes a lot of rows, does all the usual DB stuff and commits. And you are saving a single memory copy here ?

    And the really performance-wise important topics may be mentioned but skipped, ex.

    Chapter 10: Foreign Keys
    QUOTE
    It's technically possible that a CHECK constraint will not be violated at the time you update a row, but it will be violated by the time the SQL statement ends ... Because of these possibilities, ... DBMS will wait until the end of the statement before testing a constraint for violations. Thus, every row has to be accessed twice-once to change it, and a second time later on to test for constraint violations.
    END QUOTE
    Now, _that_ would be a huge performance hit sometimes. Any discussion ? Clues or hints may be ? Nope. Well, thanks for mentioning anyway (and I'm serious right now).

    The book lacks any hardware-related details, ex. how CPU, memory or I/O affect things. It lacks any database-specific details. It lacks any common approach to optimization, there is no single direction in which it leads you.

    Therefore, here is my bottom line for this book - a good overview, yes. Many interesting and fascinating details, yes. A lot of hints, oh yes ! Detailed, sometimes. Practical, uhm, unlikely.
    Comment Comment | Permalink | Was this review helpful to you? Yes No (Report this)



     
    9 of 9 people found the following review helpful:
    5.0 out of 5 stars A deeper look at SQL queries, March 26, 2003
    By David W. Smith (Silicon Valley) - See all my reviews
    (REAL NAME)   
    There's a lot of ground to cover between being able to put together a SQL query that runs and being able to construct a query that works well. The journey is all the more complicated when you're trying to target multiple RDBMSes, each with its own nuances and oddities. That's where this book shines. By going for breadth--picking 8 major RDMBS and contrasting how they behave in the face of various SQL constructs and optimizations, plus covering some general theory, this book conveys a quality of information that vendor-specific books lack. I knew a fair amount about databases and SQL before picking up the book, and came away with a much better feeling for the terrain, and a new set of optimization tricks.

    It's unfortunate, but perhaps unavoidable, that some details (e.g. lack of information on transactions and subselects in MySQL) where out-of-date by the time the book was published. It's also unfortunate that the authors were prevented by vendor license agreements from providing performance hard numbers.

    Don't get this book to learn how to optimize for a particular vendor's database. Study it to broaden your skills.

    Comment Comment | Permalink | Was this review helpful to you? Yes No (Report this)



     
    7 of 7 people found the following review helpful:
    5.0 out of 5 stars very recommendable, September 30, 2002
    I've just finished chapter 7 and 15. The book offers quite interesting information. It's written very well and easy to understand. Plus a special sense of humor ;-)
    The information gathered must not be used immediately, but helps when making decisions on database design and usage. This is because, you gain an overview on what the "big eight" do, thus you better understand what your decision could mean, when switching databases.
    It's a book suitable for both experts and beginners, though basic sql knowledge is expected.
    Comment Comment | Permalink | Was this review helpful to you? Yes No (Report this)


    Share your thoughts with other customers: Create your own review
     
     
    Ad
     
    Most Recent Customer Reviews

    5.0 out of 5 stars Very Useful SQL Book
    Every professional programmer (and DBA) should have a good book or two on SQL. There are many to choose from, and a lot of them are very good. Read more
    Published 8 months ago by Data Guy

    5.0 out of 5 stars Just for SQL experts
    If you need a support for performance issues with any SQL this book is great.

    Published 11 months ago by Beto Bens

    5.0 out of 5 stars This book should be on every DB2 Developer's Desk
    This is one of the few SQL books that has practical examples and addresses DB2, Informix, SQL Server, and Oracle. Read more
    Published on July 26, 2004 by Philip K Gunning

    5.0 out of 5 stars very well written RDBMS book
    Over the years I've developed a number of systems that utilized relational databases. When I developed or used a complex and/or large database, more often than not I found that... Read more
    Published on April 30, 2003 by uniq

    3.0 out of 5 stars Not enough vendor-specific detail
    The book gives many examples of how to fine-tune SQL statements, and usually displays performance gain/loss resulted from the fine-tuning right below the examples. Read more
    Published on March 7, 2003 by johnzhang

    5.0 out of 5 stars One of the Best SQL Reference Books Ever
    This book, SQL Performance Tuning, has proved to be one of the most invaluable books in my reference collection of SQL books. Read more
    Published on January 17, 2003 by Teddy N. Johnston

    5.0 out of 5 stars SQL Perforfmance Tuning
    Out of 25 plus books I have read on SQL, this is the best book yet I have found for performance tuning. 90% of the programmers in our shop have puchased their own copy. Read more
    Published on January 16, 2003 by Stephen Stanley

    Only search this product's reviews



    Customer Discussions

     Beta (What's this?)
    New! See all customer communities, and bookmark your communities to keep track of them.
    This product's forum (0 discussions)
      Discussion Replies Latest Post
      No discussions yet

    Ask questions, Share opinions, Gain insight
    Start a new discussion
    Topic:
    First post:
    Prompts for sign-in
      [Cancel]


    Active discussions in related forums
       


    Product Information from the Amapedia Community

    Beta (What's this?)

    Listmania!


    Look for Similar Items by Category


    Work and Roll with DEWALT

    DEWALT Job Site Radio
    While supplies last, enjoy special pricing on the DEWALT work site radio. Power it and you'll be rockin' and chargin' your way through a hard day of work.

    Shop more chargers and radios

     

    Best Books of 2008

    Best of 2008
    Find our top 100 editors' picks as well as customers' favorites in dozens of categories in our Best Books of 2008 Store.
     

    Shop Twilight Decals

    Twilight Decals
    Put a little Twilight on your ride with these quality decals.

    Shop all Twilight decals

     
    Shop inverters for your MP3 Player
    Groove on the GoKeep your MP3 player charged as you travel. Find functional and durable inverters in the Home Improvement Store.
     
    Ad

     

    Feedback

    If you need help or have a question for Customer Service, contact us.
     Would you like to update product info or give feedback on images?
    Is there any other feedback you would like to provide?

    Your comments can help make our site better for everyone.


    Where's My Stuff?

    Shipping & Returns

    Need Help?

    Your Recent History

      (What's this?)
    You have no recently viewed items or searches.

    After viewing product detail pages or search results, look here to find an easy way to navigate back to pages you are interested in.

    Look to the right column to find helpful suggestions for your shopping session.

    Continue shopping: Top Sellers
    Free
    Free by Chris Anderson
    Paranoia
    Paranoia by Joseph Finder
    My Soul to Lose
    My Soul to Lose by Rachel Vincent
    Darkfever
    Darkfever by Karen Marie Moning

    Conditions of Use | Privacy Notice © 1996-2009, Amazon.com, Inc. or its affiliates