Re: Need help turning OUTER JOIN query into UNION query

Welcome to the Wonderful World of Siebel.

I used a FIRST_ROWS hint and got the time down from 4 mins 51 secs to 5 secs.

However, Siebel won't let us use hints. Or Cost based optimizer. Or Partitioning.

I'll put the explain plan output here, but trust me, it's doing a full table scan.

Feel free to copy and paste it and run explain plan on it.

"Tom Dyess" <tdyess_at_dyessindustries.com> wrote in message news:<oSH58.158649$_w.24645083_at_typhoon.tampabay.rr.com>...
> God, that query was ugly.
>
> Tom
> www.oraclepower.com
>
Received on Wed Jan 30 2002 - 04:21:37 CST