logo
Toggle navigation
Begin main navigation
About
Projects
Download
Documentation
Wiki
Forums
Log In
Go!
OpenACS – The Toolkit for Online Communities
:
Forums
:
OpenACS Q&A
:
Strange query performance when using <b>UNION</b>
: One Message
Begin main content
Forum OpenACS Q&A: Re: Strange query performance when using <b>UNION</b>
Search:
Back to OpenACS Q&A
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.
Back to OpenACS Q&A