Hi Hugo,

Thanks for the article.

I went ahead and ran the code in Listing 9-3 on SQL Server 2012 instance, and checked the execution plan with and without the optimizer, but did not see anything like Figure 9-6.

Figure 9-6 seems completely off because it shows Physical operation : Hash Match, yet Logical operation: Inner Join. I don't see such operator in the execution plan of any of the code in the List 9-3. Any "Hash Match" I have seen so far has the logical operation of "Aggregation", not "Inner Join", so I am confused here.

Thanks,