![[assets/ex_subqueryscan.png|256]] - **Description**: Scans the result of a subquery. - **Performance**: Depends on the subquery. - **Factors**: Subquery complexity, size. - **Cost**: Subquery cost. - ![[assets/ex_subplan.svg|200x200]] - **Operates on**: [[Structures/Result Set]] - **Workloads**: - [[Workloads/LWLock]] - [[Workloads/Sub/BufferContent]]