5 ms·
Typically I advise people to use CTE's for ad hoc queries and to avoid CTE's for production code. CTE's are easily abused.
by iblaine 11y ago
Typically I advise people to use CTE's for ad hoc queries and to avoid CTE's for production code. CTE's are easily abused.
- atwebb 11y agoEasily abused and can throw the optimizer for a loop, especially if using them to reference within the CTE (not a recursive CTE but joining back).