I scanned the article quicly and it is well presented.

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.

No time no to go deep into this, but I will 😉

Thx for the article in advance!