Reduce Query Resource Use

  • Grant Fritchey


In the previous chapter you focused on writing queries in such a way that they appropriately used indexes and statistics. In this chapter, you’ll make sure you’re writing a queries in such a way that they don’t use your resources in inappropriate ways. There are ways to write queries that avoid using memory, CPU, and I/O, as well as ways to write the queries that use more of these resources than you really should. I’ll go over a number of mechanisms to ensure your resources are used optimally by the queries under your control.


Data Type Execution Plan Select Statement Database Application Multiple Query 

Copyright information

© Grant Fritchey 2014

Authors and Affiliations

  • Grant Fritchey
    • 1
  1. 1.MAUS

Personalised recommendations