What is a federated query
A federated query puts the results of two queries together vertically, which requires that the columns from the two queries be exactly the same.
Joint query optimization
Union all is more efficient than union (union all displays duplicate results, union overlaps duplicate content)