Comparing Join Algorithms
Algorithm |
Analytic |
Interactive |
Include Reference Table |
Nested Loops |
20,001,000 |
1,001 |
21,000 |
Nested Loops (improved) |
1,001,000 |
1,001 |
2,000 |
Block Nested Loops |
12,000 |
1,001 |
1,011 |
Index Nested Loops |
41,000 |
3 |
41,000 |
Sort Merge |
2,000 |
1,001 |
1,001 |
|