Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Index Range Scans....

Re: Index Range Scans....

From: Miggins <mtproc_at_yahoo.co.uk>
Date: 3 Mar 2006 06:57:32 -0800
Message-ID: <1141397852.165517.81340@i39g2000cwa.googlegroups.com>


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.

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. Received on Fri Mar 03 2006 - 08:57:32 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US