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

Collapse
10: Re: Strange query performance when using <b>UNION</b> (response to 1)
Posted by Brian Fenton on 03/24/05 04:33 PM
Hmmm.. looks like you could be onto something there. AskTom has an article about this
http://asktom.oracle.com/pls/ask/f?p=4950:8:::::F4950_P8_DISPLAYID:3561623983484

In 8i the parameter is called _COMPLEX_VIEW_MERGING and it's undocumented. I'll play around a bit with this on test before touching production. This is starting to look quite hairy indeed....

Thanks for the wisdom Dirk!