If both join inputs are large and the two inputs are of similar sizes, a merge join with prior sorting and a hash join offer similar performance.

• 如果两个联接输入都很大,而且这两个输入的大小差不多,则预先排序的合并联接提供的性能与哈希联接相近。