*** 86,92 **** Option 1, on the other hand, has to run both its outer loop and its middle loop 3500 times each, resulting in 12 million iterations of the middle loop. Thus in the second scenario, option 2 is ! nearly 2000 times faster than option 2. So you can see that depending on how the data is structured in the table, either query plan 1 or query plan 2 might be better. How --- 86,92 ---- Option 1, on the other hand, has to run both its outer loop and its middle loop 3500 times each, resulting in 12 million iterations of the middle loop. Thus in the second scenario, option 2 is ! nearly 2000 times faster than option 1. So you can see that depending on how the data is structured in the table, either query plan 1 or query plan 2 might be better. How