Re: Influence Optimzer to merge 'IN' subquery

mccmx_at_hotmail.com (Matt) wrote:
> >
> > One possiblity ... replace IN with EXISTS.
>
> That would achieve the exact opposite of the order I want.

How do you know that?

> I want to
> drive from the subquery into the outer query, but exists implicitly
> drives from the outer to the inner.

The Oracle optimizer does what it does, regardless of your beliefs. For some reason, it often makes better choices with exists queries than it does with in-list queries. And often that choice includes swapping the join order.

Xho

-- 
-------------------- http://NewsReader.Com/ --------------------
Usenet Newsgroup Service                        $9.95/Month 30GB