Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: Performance Problems with Ora 7.33
Kevin Loney wrote in message ...
>Most likely culprit: hash joins.
I beg to differ, especially in the data warehouse environment. I've seen hash joins outperform nested loop joins manyfold. And the reverse of course too. :-)
>In init.ora, set HASH_JOIN_ENABLED=FALSE
>and restart and try again.
Do not agree. There are situations where hash joins are faster than nested loop joins. Rather than simply disabling a feature, rather make sure it is used correctly.
My 2'c...
regards,
Billy
Received on Thu Nov 05 1998 - 07:44:27 CST
![]() |
![]() |