DB2 must deduplicate before the outer query can process results. - **GROUP BY with aggregation** — Aggregates must complete before outer predicates can apply. - **UNION** (but not UNION ALL) — Deduplication creates a fence. - **OLAP/window functions** — Must compute over the complete partition befor