• Thanks for the question,

    Thankfully for me this was a theoretical question at an upper level, not to dig into the query plan to see what the query processor does!

    As per BOL

    The UNION operation is different from using joins that combine columns from two tables.