UNION ALL Optimization

The following examples use two tables with identical contents: A million rows of integers from one to a million. One table is a heap with no nonclustered indexes; the other has a unique clustered index: [crayon-5952c426e67fc757049902/] No Row Goal The following query looks ...