On 22 Feb 2005 at 8:39, Robert martin wrote:

>We have a number of Union queries that join two tables that have
>guaranteed unique values. We currently use Union to merge them.
>Would Union All provide better performance as it doesn't have to do
>any checking for 'Distinctness'?

Yes. And a big one.
--
SY, Dimitry Sibiryakov.