Jack Corbett (8/22/2013)
The attached execution plan doesn't include the UNION. A UNION ALL there if you know there are no duplicates would help some. Also your execution plan doesn't show 1.2 million rows it is showing 35 rows total.
Attached single loop execution plan only thats why it is showing 35 rows and taken execution plan without "union operator" in insert script