I talked about memory latency with respect to joins - that the random access in the hash table is much slower per "row" than vectorized operations on columns. I

I talked about memory latency with respect to joins - that the random access in the hash table is much slower per "row" than vectorized operations on columns. I didn't say I/O would be slow. That I said hash table implies that one side is fully loaded into RAM.