Union will return the records that have common in both of them and all values should have unique values but in union all it should have duplicate values and there is a performance hit in union all