a powerful join strategy when there is a need to merge two data streams, but the order of the result is not valuable for subsequent query processing steps (in other words, no sorting of the data is required)

A method for joining two or more files together that uses a hash value to find the matching keys.

A join operation in which Cloudscape uses a hash table for performance reasons. It is suitable for joins in which the outer table’s values are joined with single rows in the inner table, and values in the inner table are unique. See Nested loop join for comparison.