|< < 17 > >|

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

|< < 17 > >|