My Instructor Resource Center : Log in or request access
SQL Performance Tuning
ISBN-10: 0201791692
ISBN-13: 9780201791693
Publisher: Addison-Wesley Professional
Copyright: 2003
Format: Paper; 528 pp
Published: 09/10/2002
Status: Out of Stock
This item is temporarily out of stock.
Customers outside the U.S., click here.
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.
Appendix A. Further Reading.
Appendix B. Glossary.
Index. 0201791692T08272002
View a Sample Chapter PDF:/samplechapter/0201791692.pdf
Peter Gulutzan is a principal of Ocelot Computer Services Inc. in Alberta, Canada. Peter is a technical writer and computer programmer who has worked with SQL since 1986. With Trudy Pelzer, he has written three books, Optimizing SQL (CMP Books, 1994), Optimizing C with Assembly Code (CMP Books, 1995), and SQL-99 Complete, Really (CMP Books, 1999).
Trudy Pelzer is a principal of Ocelot Computer Services Inc. in Alberta, Canada. Trudy is a technical writer and computer programmer who has worked with SQL since 1986. With Peter Gulutzan, she has written three books, Optimizing SQL (CMP Books, 1994), Optimizing C with Assembly Code (CMP Books, 1995), and SQL-99 Complete, Really (CMP Books, 1999).
0201791692AB07012002
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:
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
Log in to the Instructor Resource Center
Login name:
Password:
Forgot login/password? | Need to redeem an access code?
Instructor Resource Center File Download
This work is protected by local and international copyright laws and is provided solely for the use of instructors in teaching their courses and assessing student learning. Dissemination or sale of any part of this work (including on the World Wide Web) will destroy the integrity of the work and is not permitted. The work and materials from this site should never be made available to students except by instructors using the accompanying text in their classes. All recipients of this work are expected to abide by these restrictions and to honor the intended pedagogical purposes and the needs of other instructors who rely on these materials.| Cancel | I accept, proceed with download |
Pearson Higher Education offers special pricing when you choose to package your text with other student resources. If you're interested in creating a cost-saving package for your students contact your Pearson Higher Education representative.
