4 ms·
I personally find CTEs much easier to read than subqueries.
by Xophmeister 10y ago
I personally find CTEs much easier to read than subqueries.
- wesd 10y agoand you can use them in multiple places. I'm not sure if you have the same subquery twice if the query optimizer uses a single dataset.
- deleted 10y ago[deleted]
- deleted 10y ago[deleted]
- goldenkey 10y agoBe careful though, above poster mentions that a chain of CTE is almost certain to lead to sequential scans rather than parallelized (optimized) execution.