- **Description**: Handles recursive CTEs.
- **Performance**: Handles recursive queries, can be slow.
- **Factors**: Recursion depth, size of intermediate results.
- **Cost**: `iteration cost * number of iterations`
- ![[ex_recursive_union.svg|200x200]]
- **Operates on**: [[Result Set]]