Re: Tuning a full outer join

Hey Morgan... you idiot.... you out there?

Richard Kuhler wrote:

> Daniel Morgan wrote:
> <snip>
>
> > It would appear that you never ran DBMS_STATS and produced statistics for
> > the CBO.
>
> I was showing that example only as a demonstration of how you apparently
> can't influence the optimizer for the 'anti-join'. I'm not trying to
> tune that query specifically. My real database is well analyzed and
> indexed.
>
> > And I'd be far more concerned about the apparent lack of indexes, or at
> > least their usage,
> > then how Oracle might choose an execution path.
>
> My actual query relies on results that can't be indexed (they come from
> pipeline table functions).
>
> Anybody have an answer for my actual question? How do you influence the
> 'anti-join' method of a full outer join query?
>
> Richard
Received on Thu Jun 05 2003 - 21:24:35 CDT