Indexing for Windowing Functions (45 minutes)

Get the best performance for your windowing functions.

Windowing functions give you great flexibility for analyzing data in SQL Server, but can be tricky to index.

In this course, you will:

  • Learn index design for windowing functions
  • Learn when batch mode may be important for window function performance
  • Compare the performance of Window Spool and Window Aggregate operators

Get the scripts

https://github.com/LitKnd/SQLWorkbooks/tree/main/indexing_for_windowing_functions

Each video in this course has English captions available, as well as a transcript below the video.

Lessons