- **Description**: Joins tables using merge join algorithm. - **Performance**: Efficient for sorted inputs. - **Factors**: Size of input datasets, sort order. - **Cost**: `sort cost + cpu_operator_cost * rows joined` - ![[ex_merge_semi_join.svg|200x200]] ![[ex_merge_anti_join.svg|200x200]] - **Operates on**: [[Result Set]]