kalau dari sisi performance, mungkin perlu harus dipertimbangkan lagi. banyak cara utk menghindari full outer join yang high cost ini. kalau table isinya hanya bbrp records mungkin gak berasa.
Remember, the OUTER JOINS are always expensive....we should use them only when they make sense... refference: 1. Effective Oracle by Design karangan Tom Kytes. 2. http://www.nodroidsallowed.com/2007/12/18/outer-joins-are-evil/ http://asktom.oracle.com/pls/asktom/f?p=100:11:0::::P11_QUESTION_ID:22868017492361 On 4/22/10, Agus Tri Laksono <[email protected]> wrote: > wow... bagus nih lebih ringkes nambah ilmu deh jadinya, tapi ada yang > kelewat bos..ini saya benerin dikit yeee > select nvl(table_1.A,table_2.A) a,table_ 1.B, table_1.C,table_ 2.D,table_ > 2.E > > from table_1 > > full outer join table_2 > > on table_1.A=table_ 2.A > > Thx > ATL > > --- On Thu, 4/22/10, Rudy W Sitanggang <[email protected]> wrote: > > From: Rudy W Sitanggang <[email protected]> > Subject: Re: [indo-oracle] newbie tanya query.. > To: [email protected] > Date: Thursday, April 22, 2010, 10:43 AM > > > > > > > > > > > > > > > > > > Ini namanya full outer join. > > > > Ini contohnya: > > > > select table_1.A,table_ 1.B, table_1.C,table_ 2.D,table_ 2.E > > from table_1 > > full outer join table_2 > > on table_1.A=table_ 2.A > > > > Semoga membantu. :) > > > > Warm regards, > > > > Rudy Wardhany > > > > Yahoo ID: rudy_staredge@ yahoo.com > > > > [Non-text portions of this message have been removed] > > > > > > > > > > > > > > > > > > > > > > > > > > [Non-text portions of this message have been removed] > >
