SQL Performance Tuning

Peter Gulutzan, Trudy Pelzer

510 pages, parution le 04/10/2002

Ajouter à une liste

Indisponible

Résumé

SQL Performance Tuning is a handbook of practical solutions designed for today's busy database professional charged with managing an organization's critically important data. Covering the 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 practical guide covers SQL commands and queries across a wide range of conditions and environments. This book covers every facet of the SQL environment, 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. 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.

Complete coverage includes:

General and specific tuning
General sort considerations and options
Joins and subqueries
Columns and tables
Indexes, including B-trees andbitmap
Constraints and stored procedures
ODBC and JDBC
Data changes and concurrency control (locking)
Clients and Servers and middleware

Whether you're a programmer, consultant, or user, you'll find SQL Performance Tuning an indispensable guide tooptimizing SQL performance across today's popular database environments.

Contents

Preface.
1. Facilis descensus Arverni.
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.
Appendix A. Glossary.
Appendix B. For Further Reading.
Index.

Caractéristiques techniques

	PAPIER
Éditeur(s)	Addison Wesley
Auteur(s)	Peter Gulutzan, Trudy Pelzer
Parution	04/10/2002
Nb. de pages	510
Format	18,5 x 23,5
Couverture	Broché
Poids	800g
Intérieur	Noir et Blanc
EAN13	9780201791693
ISBN13	978-0-201-79169-3