4 ms·Only when the CTE is referenced once. If it's referenced more than once, it is automatically materialized.by srcreigh 4y agoOnly when the CTE is referenced once. If it's referenced more than once, it is automatically materialized.