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: Outer Join Performance

Re: Outer Join Performance

From: Bert Scalzo <bscalzo01_at_7-11.com>
Date: Fri, 26 Mar 1999 11:11:00 -0600
Message-ID: <7dgf0t$3ro$1@news.ses.cio.eds.com>


You are correct. Outer Joins are not necessarily bad. Explain Plans should be checked
fro all code, not just outer joins, and inefficient code should be corrected. Your management
is looking for a non-extistent silver bullent to think that this approach will make things better ...

Bert Scalzo
DBA
EDS Julia Cristina Varela de Montoya <jc_va_at_hotmail.com> wrote in message news:7dev3g$6gr$1_at_bgtnsc01.worldnet.att.net...
> Our directors are under the assumption that outer-joins cause a
performance
> decrease, and have instructed me to remove them from various places in
code,
> regardless of the fact that fewer rows may return.
>
> After doing explain plans, I see that outer-joins have less execution
steps,
> and do in fact return rows faster. Can someone summarize for me what I
can
> say to management, or am I dreaming?
>
>
Received on Fri Mar 26 1999 - 11:11:00 CST

Original text of this message

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