Forum OpenACS Q&A: Re: Strange query performance when using <b>UNION</b>

Collapse
3: Re: Strange query performance when using <b>UNION</b> (response to 1)
Posted by Dirk Gomez on 03/23/05 04:07 PM
A union weeds out duplicates - for this to do Oracle needs to perform an implicit sort by. Can you rule out duplicates? If yes, try union all which does not remove duplicates.