InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comWed, 19 Jun 2013 11:52:50 GMT20http://www.sqlservercentral.com/Forums/Topic1400858-1044-1.aspx[quote][b]Raghu.K (12/28/2012)[/b][hr]I want join 4 tables in the Oracle.Table 1 is having 4 different where conditions.Which one is better (Performance wise)1.Join all 4 tables and write table1 where conditions globally (After Joining 4 tables)2.Make Table1 as Derived Table with all where conditions and joining with 3 tables.[/quote]Not much to work with.Assuming you have the right indexes on place, test both cases. Since this is an Oracle question I would suggest to trace/tkprof both solutions then look at buffer_gets on both of them, usually the solution with the less buffer_gets would be the one that would perform the better.Hope this helps.Tue, 22 Jan 2013 18:35:04 GMTPaulB-TheOneAndOnlyhttp://www.sqlservercentral.com/Forums/Topic1400858-1044-1.aspxGenerally speaking (as this is a general question), probably Option 1 as it lets Oracle pick the best way of applying predicates. Under limited circumstances, option 2 will limit the way in which it applies predicates.Ask a general question get a general answer.Mon, 21 Jan 2013 17:12:04 GMTnick.mcdermaidhttp://www.sqlservercentral.com/Forums/Topic1400858-1044-1.aspxCan't tell much without actually seeing it. I had success using [url=http://www.orafaq.com/forum/]orafaq[/url], just be sure you read the forum guide. Do you have a testcase (create table, insert data, select query,query plan)?Fri, 28 Dec 2012 12:02:35 GMTJo Pattynhttp://www.sqlservercentral.com/Forums/Topic1400858-1044-1.aspxTest them and see?Alternately, maybe ask on an Oracle forum where you're more likely to get an answer.Fri, 28 Dec 2012 03:50:46 GMTGilaMonsterhttp://www.sqlservercentral.com/Forums/Topic1400858-1044-1.aspxHi Please help me...I want join 4 tables in the Oracle.Table 1 is having 4 different where conditions.Which one is better (Performance wise)1.Join all 4 tables and write table1 where conditions globally (After Joining 4 tables)2.Make Table1 as Derived Table with all where conditions and joining with 3 tables.Please help meFri, 28 Dec 2012 03:45:42 GMTRaghu.K