Thanks Dimitry

I have converted my Unions and receive about a 10x performance boost !

Rob Martin
Software Engineer

phone +64 03 377 0495
fax +64 03 377 0496
web www.chreos.com

Wild Software Ltd



Dimitry Sibiryakov wrote:

>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.
>
>