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: Performance Problems with Ora 7.33

Re: Performance Problems with Ora 7.33

From: Billy Verreynne <vslabs_at_onwe.co.za>
Date: Thu, 5 Nov 1998 15:44:27 +0200
Message-ID: <71sa86$bib$1@hermes.is.co.za>


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

Original text of this message

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