• It might be worth noting that when using UNION, more work must be done to find the duplicates rows. We have found that using UNION ALL returns data much faster when large result sets are being returned and you know that the data being returned by the queries are mutually exclusive.