MIME-Version: 1.0
In-Reply-To: <CAMNBsZv3_BdJxQF+TZESfFAEnfszLa_ypGEZ3jax+xsWdAiK0g@mail.gmail.com>
References: <CAMNBsZvYSOAQ23hUKsYQu7vQx3nb68Q7YjFTi2KD_GXuMdmKZw@mail.gmail.com>
 <CAMNBsZvHh3rbFE1pK6yLpX0w=9tWU+u0jjzzhvaJzXYH=8ayzA@mail.gmail.com>
 <CAMNBsZu+1CuZFfDz6rm5WoMz14mMhKN2SS_26w=RNJdEgYW9hw@mail.gmail.com> <CAMNBsZv3_BdJxQF+TZESfFAEnfszLa_ypGEZ3jax+xsWdAiK0g@mail.gmail.com>
From: Sayan Malakshinov <xt.and.r@gmail.com>
Date: Fri, 3 Mar 2017 11:46:35 +0300
Message-ID: <CAOVevU5=b6Ynu5f0cpvt8BR-uf8BnBCsJwhsrZzNdhvgkCohxw@mail.gmail.com>
Subject: Re: Outer Joins and IN / NOT IN
To: Hemant K Chitale <hemantkchitale@gmail.com>
Cc: ORACLE-L <oracle-l@freelists.org>
Content-Type: multipart/alternative; boundary=001a114108dc62ef940549cf9571
Sender: oracle-l-bounce@freelists.org
Errors-to: oracle-l-bounce@freelists.org
Precedence: normal
Reply-To: xt.and.r@gmail.com
--001a114108dc62ef940549cf9571
Content-Type: text/plain; charset=UTF-8

Hi Hemant,

No, at least full outer join, because it could be executed as native full
outer join operation, and you can't get this operation using in/not in and
native oracle sql(+).

Best regards,
Sayan Malakshinov
http://orasql.org

On Mar 3, 2017 09:42, "Hemant K Chitale" <hemantkchitale@gmail.com> wrote:

> Is there truth to the belief that LEFT and FULL Outer Joins should
> (always) be rewritten for performance ?  I don't have the tables and SQLs
> so this was just an exploratory talk. My point is that we should write what
> seems obvious and is easy to understand rather than use convoluted
> subqueries.
>
>
> Hemant K Chitale
> Sent from my smartphone
>
>

--001a114108dc62ef940549cf9571
Content-Type: text/html; charset=UTF-8
Content-Transfer-Encoding: quoted-printable

<div dir=3D"auto">Hi Hemant,=C2=A0<div dir=3D"auto"><br></div><div dir=3D"a=
uto">No, at least full outer join, because it could be executed as native f=
ull outer join operation, and you can&#39;t get this operation using in/not=
 in and native oracle sql(+).<br><br><div data-smartmail=3D"gmail_signature=
" dir=3D"auto">Best regards, <br>Sayan Malakshinov <br><a href=3D"http://or=
asql.org">http://orasql.org</a> </div></div></div><div class=3D"gmail_extra=
"><br><div class=3D"gmail_quote">On Mar 3, 2017 09:42, &quot;Hemant K Chita=
le&quot; &lt;<a href=3D"mailto:hemantkchitale@gmail.com">hemantkchitale@gma=
il.com</a>&gt; wrote:<br type=3D"attribution"><blockquote class=3D"gmail_qu=
ote" style=3D"margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex=
"><div dir=3D"auto">Is there truth to the belief that LEFT and FULL Outer J=
oins should (always) be rewritten for performance ?=C2=A0 I don&#39;t have =
the tables and SQLs so this was just an exploratory talk. My point is that =
we should write what seems obvious and is easy to understand rather than us=
e convoluted subqueries.<br><br><div data-smartmail=3D"gmail_signature"><br=
>Hemant K Chitale<br>Sent from my smartphone<br>=C2=A0=C2=A0=C2=A0 </div></=
div>
</blockquote></div></div>

--001a114108dc62ef940549cf9571--
--
http://www.freelists.org/webpage/oracle-l