Performance of UNION versus UNION ALL in SQL Server

Viewed 33621

I have to run a SELECT statement across several tables. I am sure the tables return different records. I am anyway using UNION ALL.

Is it better to use UNION or of UNION ALL in performance terms when I am sure the tables return different records?

5 Answers
Related