![[assets/ex_ctescan.png|256]] - **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. - ![[assets/ex_cte_scan.svg|200x200]] - **Operates on**: [[Structures/Result Set]] - **Workloads**: - [[Workloads/IO]] - [[Workloads/Sub/BufFileRead]] - [[Workloads/Sub/BufFileWrite]] - [[Workloads/LWLock]] - [[Workloads/Sub/SharedTupleStore]] - [[Workloads/Sub/BufferContent]]