3 ms·
They still are sometimes. Whenever you have a CTE which is referenced more than once, to be specific.
by srcreigh 4y ago
They still are sometimes. Whenever you have a CTE which is referenced more than once, to be specific.
- heresjohnny 4y agoSimilarly, joining a CTE to itself can also be problematic. In that case materializing to a temp table can be faster.