![[assets/ex_nestedloop.png|256]] - **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` - ![[assets/ex_nested_loop_semi_join.svg|200x200]] ![[assets/ex_nested_loop_anti_join.svg|200x200]] - **Operates on**: [[Structures/Page]] - **Workloads**: - [[Workloads/IO]] - [[Workloads/Sub/DataFileRead]] - [[Workloads/LWLock]] - [[Workloads/Sub/BufferContent]] - [[Workloads/Sub/BufferMapping]]