It then scans the larger table, and performs the same hashing algorithm on the join column(s). It then probes the previously built hash table for each value and if they match, it returns a row. Nested Loops joins - Nested loops joins are useful when small subsets of data are being ...