Advertisement

Reduce Query Resource Use

  • Grant Fritchey
Chapter

Abstract

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.

Keywords

Data Type Execution Plan Select Statement Database Application Multiple Query 
These keywords were added by machine and not by the authors. This process is experimental and the keywords may be updated as the learning algorithm improves.

Copyright information

© Grant Fritchey 2014

Authors and Affiliations

  • Grant Fritchey
    • 1
  1. 1.MAUS

Personalised recommendations