- **Description**: Scans a Common Table Expression (CTE). - **Performance**: Depends on the materialized CTE. - **Factors**: Size and complexity of the CTE. - **Cost**: Materialization cost of the CTE. - ![[ex_cte_scan.svg|200x200]] - **Operates on**: [[Result Set]] - **Workloads**: - [[IO]] - [[BufFileRead]] - [[BufFileWrite]] - [[LWLock]] - [[SharedTupleStore]] - [[BufferContent]]