Nested loop join
Appearance
The naive algorithm that joins two relations and by making two nested loops:
For each tuple in R as r do For each tuple in S as s do If r and s satisfy the join condition Then output the tuple <r,s>
The algorithm runs in I/Os, where and is the number of tuples contained in and respectively. Can easily be generalized to join any number of relaitons.