1. Home
  2. SQL
  3. Sql tuning

Chapter 9. Special Cases

Defer no time; delays have dangerous ends.

William Shakespeare King Henry the Sixth, Part I

This chapter covers a collection of special cases that occasionally arise. Chapter 6 and Chapter 7 cover standard solutions to standard classes of the problem "What execution plan do I want?" Here, I extend those solutions to handle several special cases better.



    		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
    		Chapter 9. Special Cases
    		9.1 Outer Joins
    		9.2 Merged Join and Filter Indexes
    		9.3 Missing Indexes
    		9.4 Unfiltered Joins
    		9.5 Unsolvable Problems
    		Chapter 10. Outside-the-Box Solutions to Seemingly Unsolvable Problems
    		Appendix A. Exercise Solutions
    		Appendix B. The Full Process, End to End
    		Glossary