On 4/17/2019 4:33, Thomas Kellerer wrote:
A CTE would prevent parallelism.
You mean like always? His
SELECT count(1) FROM BigTable
would be parallel if run alone but as
WITH Data AS (SELECT count(1) FROM BigTable) SELECT * FROM Data
nothing would be parallel any more? How about:
SELECT * FROM (SELECT count(1) FROM BigTable) x
Parallel or not?
-Gunther