Thursday, June 3, 2010

Outer join use

Normally SQL does not allow to use a table with more than 1 outer join (+), how to solve the problem is a mystery for me. Previously i have read that ANSI code could be used for this though i haven' t use it yet. Today i have seen a discoverer report which uses some selects as tables to avoid outer joins and unions. Writer of the report says it also improves the performance, i will try it when the time arrives...

No comments:

Post a Comment