Get the best performance for your windowing functions. Windowing functions like ROW_NUMBER(), RANK(), and aggregate functions with OVER() clauses give you great flexibility for analyzing data, but they can be tricky to index effectively. In this course, you’ll learn how to design indexes for windowing functions, understand when batch mode is important for performance, compare Window Spool versus Window Aggregate operators, explore nonclustered columnstore indexes, and discover what indexed views can do for windowing function performance.

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