Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Index Range Scans....
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