Query Performance - Minus vs Outer Join
I like to use outer joins to find the differences in two tables while my collegue likes to use the minus query. Is there any advantage to either one?
Thanks
Andy
Example
select empId from emp a , ops b where a.empId = b.empid(+) and b.empId is null;
or
select empId from emp minus select empId from ops;