Union – Merges the Content of two or more tables without duplicates.
Union All-Merges the Content of two or more tables which include duplicates.
For union/union all between two or more tables you must have same column name including the data type.
Performance :
Union All does not requires elimination of duplicate records and the performance is high when compared with Union since it requires an additional operation to remove the duplicate values.
