This book is for readers who already know SQL and have an opportunity to tune SQL or the database where the SQL executes. It includes specific techniques for tuning on Oracle, Microsoft SQL Server, and IBM DB2. However, the main problem of SQL tuning is finding the optimum path to the data.
Table of Content:
Chapter 1. Introduction
Chapter 2. Data-Access Basics
Chapter 3. Viewing and Interpreting Execution Plans
Chapter 4. Controlling Execution Plans
Chapter 5. Diagramming Simple SQL Queries
Chapter 6. Deducing the Best Execution Plan
Chapter 7. Diagramming and Tuning Complex SQL Queries
Chapter 8. Why the Diagramming Method Works
Chapter 9. Special Cases
Chapter 10. Outside-the-Box Solutions to Seemingly Unsolvable Problems
Appendix A. Exercise Solutions
Appendix B. The Full Process, End to End
Glossary
Colophon
Index
--------------------next---------------------
阅读(284) | 评论(0) | 转发(0) |
