In terms of performance, which join method is better. And what are the drawbacks doing this way
Tab1.col1 = Tab2.col2(+)
In terms of performance, which join method is better. And what are the drawbacks doing this way
Tab1.col1 = Tab2.col2(+)
Oracle developed their (+)syntax before the ANSI committee had completed the definitions for the joins.
And no there is no performance difference.
Read more about it : Oracle Guide