Re: Hash Joins vs. Nested Loops

Galen Boyer wrote:

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

I'll help:

"If you have any questions, please consult the Oracle 10i Performance Tuning Manual".

There that should last a year or two.

Daniel Morgan Received on Wed Mar 05 2003 - 21:04:37 CST