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: Hash Joins vs. Nested Loops

Re: Hash Joins vs. Nested Loops

From: Galen Boyer <galenboyer_at_hotpop.com>
Date: 5 Mar 2003 20:57:14 -0600
Message-ID: <ur89l6n9y.fsf@hotpop.com>


On Wed, 05 Mar 2003, damorgan_at_exesolutions.com wrote:

> Galen Boyer wrote:
> 

>> On 20 Feb 2003, rgaffuri_at_cox.net wrote:
>>
>> > He said that when he tunes he generally likes to try to force
>> > nested loop joins over hash joins because these tend to increase
>> > performance? He has done this for a long time and he said that is
>> > based on experience.
>>
>> I was handed my company's PL/SQL coding guidelines which had lots of
>> performance tuning hints. I was marking the flipp'n thing up getting
>> more frustrated as I went until I happened upon, "If you have any
>> questions, please consult the Oracle 7.0 Performance Tuning Manual".
>> --
>> Galen deForest Boyer
>> Sweet dreams and flying machines in pieces on the ground.
>
> Job security or a good reason to polish up your resume'.

Nah, I just lambasted the thing and they were embarrassed as I sat there with it. We agreed to rewrite it.

-- 
Galen deForest Boyer
Sweet dreams and flying machines in pieces on the ground.
Received on Wed Mar 05 2003 - 20:57:14 CST

Original text of this message

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