Book description
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
- Copyright
- Preface
- Acknowledgments
- 1. Facilis Descensus Averni
- 2. Simple Searches
- 3. ORDER BY
- 4. GROUP BY
- 5. Joins
- 6. Subqueries
- 7. Columns
- 8. Tables
- 9. Indexes
- 10. Constraints
- 11. Stored Procedures
- 12. ODBC
- 13. JDBC
- 14. Data Changes
- 15. Locks
- 16. Clients and Servers
- 17. Cost-Based Optimizers
- Further Reading
- B. Glossary
Product information
- Title: SQL Performance Tuning
- Author(s):
- Release date: September 2002
- Publisher(s): Addison-Wesley Professional
- ISBN: 9780201791693
You might also like
book
SQL Tuning
A poorly performing database application not only costs users time, but also has an impact on …
book
SQL Server 2017 Query Performance Tuning: Troubleshoot and Optimize Query Performance
Identify and fix causes of poor performance. You will learn Query Store, adaptive execution plans, and …
book
High Performance SQL Server: Consistent Response for Mission-Critical Applications
Design and configure SQL Server instances and databases in support of high-throughput, mission-critical applications providing consistent …
book
SQL Server Query Performance Tuning,Fourth Edition
Queries not running fast enough? Wondering about the in-memory database features in 2014? Tired of phone …