GitHub

-- GREENWEEZ SALES OPERATIONS ANALYSIS

-- Raw data has one row per product per order. -- Aggregate to one row per order by summing turnover and margin.
GitHub

Optimizer: super-linear plan time on UNION ALL of N(N-1) CTE subqueries (~K^1.55) #22737

On a 1-row source the execute phase is essentially free, so the entire wall-clock cost is binding + optimizing — confirmed by EXPLAIN (no execution) taking ≈ the same time as the full execute. The ...