1. Home
  2. SQL
  3. Sql tuning

Appendix A. Exercise Solutions

Appendix A. Exercise Solutions

When I rest, I rust [Rast ich, so rost ich].

Anonymous German proverb

This appendix contains solutions to the exercises in Chapter 5 through Chapter 7.



    		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
    		Chapter 10. Outside-the-Box Solutions to Seemingly Unsolvable Problems
    		Appendix A. Exercise Solutions
    		A.1 Chapter 5 Exercise Solutions
    		A.2 Chapter 6 Exercise Solution
    		A.3 Chapter 7 Exercise Solution
    		Appendix B. The Full Process, End to End
    		Glossary