All Forums Database
firstj 8 posts Joined 05/08
20 Nov 2015
Left Outer Join Efficiency

I am experiencing efficiency issues when using multiple left out joins in queries.  I can resolve this by breaking up the existing query into smaller queries but I would like to know technical reasons why Left Outer Joins would experience efficiency issues.

ToddAWalter 316 posts Joined 10/11
22 Nov 2015

Need explain plans to understand what is happening with the query. Also need to understand how breaking it up helps with the efficiency issue - queries and explains. 

You must sign in to leave a comment.