Left Outer Join Efficiency

Database
Enthusiast

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.

Tags (3)
1 REPLY
Teradata Employee

Re: Left Outer Join Efficiency

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.