Home » SQL & PL/SQL » SQL & PL/SQL » full outer join performance (oracle 10g,oracle 11g)
full outer join performance [message #573105] Thu, 20 December 2012 16:09 Go to next message
sachin99
Messages: 7
Registered: December 2012
Junior Member
Can you tell me how to rewrite full outer join for better performance in oracle 11g.

I saw LATERAL keyword for left outer join for better performance.

Please give me all possible soultion for better performance?
Re: full outer join performance [message #573120 is a reply to message #573105] Fri, 21 December 2012 02:20 Go to previous messageGo to next message
Michel Cadot
Messages: 59279
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
If you need a full outer join there is no more performant way to write it than with a FULL OUTER JOIN operation.

Regards
Michel
Re: full outer join performance [message #573133 is a reply to message #573105] Fri, 21 December 2012 06:25 Go to previous message
tmanju
Messages: 1
Registered: December 2012
Location: Bangalore
Junior Member
hi manjunath here,
we should use full outer join as,
tab1 full outer join table 2 on(condition)
even the condition will match or not we will get the data from both the table with respect to the columns what are we used in select list
Previous Topic: Group by matching records
Next Topic: FirstName LastName Swap
Goto Forum:
  


Current Time: Wed Oct 01 00:41:07 CDT 2014

Total time taken to generate the page: 0.13923 seconds