> > For me it seems to be slow due to the sorting. Is this right?
> > Is this normal at all? Is it possible to make it faster?
>
> If you know, that your result does not produce duplicates
> (which are filtered away with "union") you can use a
> "union all" which should be substantially faster, since it does
> not need to sort.
Thank you to all who helped. I knew nothing about UNION ALL, but now it's
OK. Regards, Zoltan