The optimizer uses smaller of two tables to build a hash table on the join key in memory. It then scans the larger table, probing the hash table to find the joined rows. Optimizer uses if they are joined using an equi-join and large amount of date needs to joined.