![[assets/ex_mergeappend.png|256]] - **Description**: Merges sorted results from multiple subqueries. - **Performance**: Merges sorted results, efficient for large datasets. - **Factors**: Number and size of input datasets. - **Cost**: Sum of sorted subquery costs. - ![[assets/ex_merge_append.svg|200x200]] - **Operates on**: [[Structures/Result Set]] - **Workloads**: - [[Workloads/LWLock]] - [[Workloads/Sub/BufferContent]] - [[Workloads/IPC]] - [[Workloads/Sub/AppendReady]]