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


---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]

Reply via email to