title: Is an anti-join more efficient than a left outer join?
body: <p>A comment on <a href="https://stackoverflow.com/a/46382266/213136">this answer</a> notes that anti-joins may have been optimized to be more efficient that outer joins in Oracle. I'd be interested to see what explanations/evidence might support or disprove this claim.</p>