SQL Language (MOSC)

MOSC Banner

Query Performance - Minus vs Outer Join

edited May 31, 2010 9:42PM in SQL Language (MOSC) 4 commentsAnswered
 Hi,

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;

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center