Differences between UNION and UNION ALL Operators:-

1. UNION removes duplicate rows, whereas UNION ALL doesn’t.

2. UNION have to perform distinct sort to remove duplicates, which makes it less faster than UNION ALL.