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.