Re: Possible to force an index UNIQUE SCAN in a join ??

"Spendius" <spendius_at_muchomail.com> wrote:
> > If it is using a hash or sort join, then try giving it a use_nl hint,
> > rather than an index hint.

> I did, to no avail.

What does that mean? That it didn't use a nested loop at all, or that it did use one but didn't use the index unique scan in the process?

Can you post the sql and the explain plans?

Xho

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