4 ms·
> Allow common table expressions (CTE) to be inlined in later parts of the query If you were using CTEs before to improve readability of your selects, but were
by latch 7y ago
> Allow common table expressions (CTE) to be inlined in later parts of the query
If you were using CTEs before to improve readability of your selects, but weren't keeping an eye on your execution plans, this can significantly improve performance of some queries.
- mullr 7y agoAlternatively, if you were using them to force a barrier in the query plan, it could completely tank. Thankfully it can be turned off, and they did this in a major release.