- **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]] - **Workloads**: - [[IO]] - [[DataFileRead]] - [[LWLock]] - [[BufferContent]] - [[BufferMapping]]