O'Reilly logo

Microsoft® SQL Server® 2012 High-Performance T-SQL Using Window Functions by Itzik Ben-Gan

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Chapter 4. Optimization of Window Functions

This chapter describes the optimization of window functions in Microsoft SQL Server 2012. It assumes that you are familiar with analyzing graphical query-execution plans and with the core iterators such as Index Scan, Index Seek, Sort, Nested Loops, Parallelism, Compute Scalar, Filter, Stream Aggregate, and so on.

The chapter starts by introducing the data that will be used in the code samples. It then covers general indexing guidelines to support window functions of all kinds. Then I discuss the optimization of window ranking functions, which is followed by a discussion on improving parallel processing of window functions in general. The chapter then discusses optimization of aggregate and offset functions, ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required