[GENERAL] CTE materializing sets?

[Liam Caffrey]

Hi,

If I run a CTE does that materialize the resulting data in the same (or a
similar) way as if I created a temp table and referred to that instead? Or
does the CTE keep the set in memory?

Regards

Liam