I have found many who firmly believe a CTE actually creates a volatile table in tempdb and then reads from it.

i cannot figure out where they got that idea...