Databases and Performance: Nested Loop Join Costing

As described previously, the optimizer has 3 main join methods available when joining 2 data sets together: Nested Loop Join Sort Merge Join Hash Join Each method has a different associated formula for its cost of execution. Here I will look at the Nested

databaseperformance.blogspot.c