Tag
hash-join
- Apr 5, 2023 Sort, Hash, and Materialize: Memory Limits and Spill to Disk How a hash join decides it must partition, what a sort does when the work memory runs out, and why an underestimated row count becomes a disk-bound plan. databases
- Jul 19, 2022 Hash Joins and Hash Aggregation: Build, Probe, and Spill How a hash table is built from one join input, why the probe side must be streamed, and what happens when the build side exceeds the memory grant. databases