Re: Hash Joins vs. Nested Loops

From: Galen Boyer <galenboyer_at_hotpop.com>
Date: 4 Mar 2003 20:49:04 -0600
Message-ID: <un0kajr0x.fsf@hotpop.com>

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.

Received on Tue Mar 04 2003 - 20:49:04 CST