title: Performance of UNION versus UNION ALL in SQL Server
body: <p>I have to run a SELECT statement across several tables. I am sure the tables return different records. I am anyway using UNION ALL.</p>
  <p>Is it better to use UNION or of UNION ALL in performance terms  when I am sure the tables return different records?</p>