-389,160
Run1 latches total versus runs -- difference and pct
Run1 Run2 Diff Pct
119,21994,383 -24,836 126.31%
Regards,
Larry G. Elkins
[EMAIL PROTECTED]
214.954.1781
> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of
> Conn
My understanding is that the parm simply reverts you
to pre-9 behaviour where index joins were not there,
so there should be no major problems.
hth
connor
--- April Wells <[EMAIL PROTECTED]> wrote: >
> We have discovered an... opportunity... and Oracle's
> suggestion is to set
> _index_join_ena
It disables index hash joins (hashing a scan of two indexes
on a single table to generate a result without visiting the table).
If you are upgrading, you weren't using that path before, so
won't miss it if you switch it off now.
Regards
Jonathan Lewis
http://www.jlcomp.demon.co.uk
The educate
Title: _index_join_enabled in 9i
We have discovered an... opportunity... and Oracle's suggestion is to set _index_join_enabled = false
Anyone seen any detrimental effects of setting this parameter to false in 9.2.0.#?
April Wells
Oracle DBA/Oracle Apps DBA
Corporate Systems
Amarillo