A hash join is a modified version of the merge join. Oracle uses a hash function on the join criteria to eliminate the need to sort each table. The overhead of the hash function is normally less than the time required to sort the tables.