Advertisement

Tuning for Better Performance

  • Kathi Kellenberger
  • Clayton Groom
Chapter

Abstract

You have learned how to use the window function features of SQL Server 2005: ranking functions and window aggregates. Often, queries using window functions have better performance than using older methods such as self-joins and cursors. There are, however, some things you need to know to make sure your queries run as fast as possible when you use window functions.

Keywords

Ranking Function Window Function Execution Plan Segment Operator Query Window 
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

© Kathi Kellenberger with Clayton Groom 2015

Authors and Affiliations

  • Kathi Kellenberger
    • 1
  • Clayton Groom
    • 1
  1. 1.ILUnited States

Personalised recommendations