does CTE use or create temp tablespace?

[wuge]

after I convert one big no perform query to CTE,

I have Problem with .TDA files in SMS.

I want to know if CTE create or use temp table space? in my CTE query, I use distint and order. I query the table over 3 millon records.