![[assets/ex_recursiveunion.png|256]] - **Description**: Handles recursive CTEs. - **Performance**: Handles recursive queries, can be slow. - **Factors**: Recursion depth, size of intermediate results. - **Cost**: `iteration cost * number of iterations` - ![[assets/ex_recursive_union.svg|200x200]] ![[assets/ex_worktable_scan.svg|200x200]] - **Operates on**: [[Structures/Result Set]] - **Workloads**: - [[Workloads/IO]] - [[Workloads/Sub/BufFileRead]] - [[Workloads/Sub/BufFileWrite]] - [[Workloads/LWLock]] - [[Workloads/Sub/BufferContent]]