Andy Brownsword categorizes the components:
Using last week’s sample data we can run the query below to demonstrate operators typically used for a window function:
The result of this query is a set of data with a running total of the Sales Value within each Financial Quarter.
We’ll follow the data through some of the operators in this execution plan to understand their part in the function. As with regular execution plans we’ll be working from right to left.
Read on for the key operators.