text.skipToContent text.skipToNavigation
  1. Home
  2. Computer Science & IT
  3. SQL Performance Tuning

SQL Performance Tuning, 1st edition

  • Peter Gulutzan
  • Trudy Pelzer

Published by Addison-Wesley Professional (September 10th 2002) - Copyright © 2003

1st edition

SQL Performance Tuning

ISBN-13: 9780201791693

Includes: Paperback
Free delivery
$59.99

Currently unavailable

What's included

  • Paperback

    You'll get a bound printed text.

Overview

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

    Table of contents



    Preface.

    You Don't Know that Your DBMS Is Good….

    You Know that Even Good Tools Work Better in Skilled Hands….


    Acknowledgments.


    1. Facilis Descensus Averni.

    This Subject Is Important.

    The Big Eight.

    Installation Parameters.

    Test Results.

    Portability.

    Terminology and Expectations.

    Conventions.

    Generalities.


    2. Simple Searches.

    General Tuning.

    Code for Points.

    Constant Propagation.

    Dead Code Elimination.

    Ensure You Use the Right DBMS.

    Constant Folding.

    Case-Insensitive Searches.

    Sargability.

    The Bottom Line: General Tuning.

    Specific Tuning.

    AND.

    OR.

    AND Plus OR.

    NOT.

    IN.

    LIKE.

    SIMILAR.

    UNION.

    EXCEPT.

    INTERSECT.

    CASE.

    The Bottom Line: Specific Tuning.

    Style Notes.

    Parting Shots.


    3. ORDER BY.

    General Sort Considerations.

    The ORDER BY Clause.

    To Sort or Not to Sort.

    The Bottom Line: General Sorts.

    Character Sorts.

    Character Sort Support.

    Collations.

    The Bottom Line: Character Sorts.

    Other Options.

    Sort Keys.

    Encouraging Index Use.

    Preordering.

    The Bottom Line: Other Options.

    Parting Shots.


    4. GROUP BY.

    Refresher.

    Optimal GROUP BY Clauses.

    HAVING.

    Alternatives to GROUP BY.

    The Bottom Line: Optimal GROUP BY Clauses.

    For teachers

    All the material you need to teach your courses.

    Discover teaching material