3 ms·
CTEs do not get cached though, so they are actually quite bad for repetition without also using a temp table.
by achr2 6y ago
CTEs do not get cached though, so they are actually quite bad for repetition without also using a temp table.
- ComodoHacker 6y agoDepends on DBMS and version. Some are smart enough to pipeline/tie or materialize it internally.