If we want to combine data about same information from two sources, we can think of using two sql approaches: Full Outer Join shows better performance statistics in all 3 aspects: CPU, IO and Spool. Let’s say we have orders with customer info from two different data sources. Both are relevant data sets, some orders are only…