UNION Usage

Consider using UNION ALL if you do not care about duplicates:

Unlike UNION which removes duplicates, UNION ALL allows duplicate tuples. If you do not care about duplicate tuples, then using UNION ALL would be a faster option.