When to Use Nested Loops Joins If one join input is quite small (such as fewer than 10 rows), and the other join input is fairly large and indexed on its join columns, index nested loops are the fastest form of join operations because they require the least I/O and the fewest comparisons.