1. Home
  2. SQL
  3. Sql tuning

Chapter 8. Why the Diagramming Method Works

It is well to moor your bark with two anchors.

Publilius Syrus (a.k.a. Publius) Maxim 119

Chapter 5-Chapter 7 covered how to tune SQL with the diagramming method but did not discuss why the method leads to well-tuned SQL. With a lot of faith and good memory, you could likely get by without knowing why the method works. However, even with unbounded, blind faith in the method, you will likely have to explain your SQL changes occasionally. Furthermore, the method is complex enough that an understanding of why it works will help you remember its details better than blind memorization ever could.



    		Preface
    		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
    		8.1 The Case for Nested Loops
    		8.2 Choosing the Driving Table
    		8.3 Choosing the Next Table to Join
    		8.4 Summary
    		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