Make sure you have selected Query, Include Actual Execution Plan (or press the button on the tool bar).
When you run the query an extra tab will be displayed showing the Execution Plan.
UNION in the view to
UNION ALL. SQL does extra processing
when you do
UNION to ensure the rows returned are unique. As we know they
are unique we can use