Path: dp-news.maxwell.syr.edu!spool.maxwell.syr.edu!news-spur1.maxwell.syr.edu!news.maxwell.syr.edu!fu-berlin.de!uni-berlin.de!individual.net!not-for-mail
From: "Robert Klemme" <bob.news@gmx.net>
Newsgroups: comp.databases.oracle.server
Subject: Re: Index Range Scans....
Date: Fri, 3 Mar 2006 16:32:07 +0100
Lines: 24
Message-ID: <46r5rsFckp7nU1@individual.net>
References: <1141391689.633706.102630@z34g2000cwc.googlegroups.com>   <46r19kFc2r87U1@individual.net> <1141397852.165517.81340@i39g2000cwa.googlegroups.com>
Mime-Version: 1.0
Content-Type: text/plain;
 charset="iso-8859-1"
Content-Transfer-Encoding: 7bit
X-Trace: individual.net 2H70WWUHuTM5vhC3dD9v8AGb6rWg/3Db4Cf1K+r7EOLwIAe2E=
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1506
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1506
Xref: dp-news.maxwell.syr.edu comp.databases.oracle.server:262705

Miggins wrote:
> Hi,
>
> Thanks for your responses but LD.f3 doesnt equal L.f3 and the tables
> are not meant to join on these fields. LD.f3 is coming from a variable
> set elsewhere in the package.

Is this part of a stored procedure and / or do you have a stored plan?  In
that case LD.f3 would be filled from a variable and Oracle might not be
able to come up with a proper plan.  Btw, what version of Ora and OS are
we talking about?

> So am still providing all the data required to use the primary key on
> the LOG_DETAILS table.
>
> The query needs to use a NESTED LOOP but isnt. Have tried using hints
> but it still insists on using a HASH JOIN
>
> Any ideas.

It might help if you provide full version details, DDL and query.

    robert