In many small transactions, such as those affecting only a small set of rows, index nested loops joins are superior to both merge joins and hash joins.

• 在许多小事务中(如那些只影响较小的一组行的事务),索引嵌套循环联接优于合并联接和哈希联接。