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, ...
Get Microsoft® SQL Server® 2012 High-Performance T-SQL Using Window Functions now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
