- **Description**: Joins tables using a nested loop algorithm. - **Performance**: Can be slow for large datasets. - **Factors**: Size of input datasets. - **Cost**: `outer cost + inner cost * rows in outer` - ![[ex_nested_loop_semi_join.svg|200x200]] ![[ex_nested_loop_anti_join.svg|200x200]] - **Operates on**: [[Page]]