"Jonathan Lewis" <jonathan_at_jlcomp.demon.co.uk> wrote in message news:<ck3g4t$92v$1_at_hercules.btinternet.com>...
> I may be wrong with version numbers, but I think
> 8.1.7.0 - 2 were versions where the root block of
> the index on the inner table of a nested loop was
> subject to a 'get' for every row in the driving table
> instead of a 'pin' for the database call.
>
> I forget the bug number, but your statistics look
> about right for this to be the problem.
>
Thanks for the feedback... I will do a search on metalink to see if I
can find reference to that bug. However the long term plan should be
to move to 9i (9.2.0.4).
Received on Fri Oct 08 2004 - 02:41:18 CDT
