Re: Hash Joins vs. Nested Loops

From: DA Morgan <damorgan_at_exesolutions.com>
Date: Wed, 05 Mar 2003 08:33:43 -0800
Message-ID: <3E6626E7.10066658@exesolutions.com>

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'.

Dan Morgan Received on Wed Mar 05 2003 - 10:33:43 CST