Fairly sure the "standard mandates CTE optimisation fence" story is bunk. SQL standard doesn't even know about indexes. #thetruthisoutthere
Conversation
Replying to
The next one is allowed to reference the result of the previous one as if it already ran to completion, I think that's about it.