3 ms·
You can still do many subselect queries without with. Its really only an issue with the more complex usages.
by goldenkey 10y ago
You can still do many subselect queries without with. Its really only an issue with the more complex usages.
- Xophmeister 10y agoI 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.