![[assets/ex_hashjoin.png|256]] - **Description**: Joins tables using a hash table. - **Performance**: Efficient for large joins. - **Factors**: Size of join tables, hash table size. - **Cost**: `build cost + probe cost + cpu_operator_cost * rows joined` - ![[assets/ex_hash_semi_join.svg|200x200]]![[assets/ex_hash_anti_join.svg|200x200]] - **Operates on**: [[Structures/Result Set]] - **Workloads**: - [[Workloads/IO]] - [[Workloads/Sub/BufFileRead]] - [[Workloads/Sub/BufFileWrite]] - [[Workloads/LWLock]] - [[Workloads/Sub/ParallelHashJoin]] - [[Workloads/Sub/BufferContent]] - [[Workloads/IPC]] - [[Workloads/Sub/HashBuildElect]] - [[Workloads/Sub/HashBuildHashInner]] - [[Workloads/Sub/HashBuildHashOuter]] - [[Workloads/Sub/HashBatchLoad]]