- **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]] - **Workloads**: - [[IO]] - [[BufFileRead]] - [[BufFileWrite]] - [[LWLock]] - [[BufferContent]]