peter-757102 (4/26/2010)
I scanned the article quicly and it is well presented.
Thanks very much.
But I do have to dive into this particular one as I feel something odd is happening. The optimized statement is still just one statement and the steps in the with clause are no more then inline views. I am interested in why this construct manages to forces a way better execution plan.
You are right to suspect that there is rather more to it than that 😉
I hope you find time for a proper read of it very soon. Please also take a look at the attached scripts if you can.
Paul White
SQLPerformance.com
SQLkiwi blog
@SQL_Kiwi