- **Description**: Computes window functions.
- **Performance**: Computes window functions, can be CPU-intensive.
- **Factors**: Number of rows, window function complexity.
- **Cost**: `window function cost * number of rows`
- ![[assets/ex_window_aggregate.svg|400]]
- ![[assets/ex_window_aggregate.svg|150x150]]
- **Operates on**: [[Structures/Result Set]]
- **Workloads**:
- [[Workloads/IO]]
- [[Workloads/Sub/BufFileRead]]
- [[Workloads/Sub/BufFileWrite]]
- [[Workloads/LWLock]]
- [[Workloads/Sub/BufferContent]]