The Mangled Outer Join

Question

The Mangled Outer Join

Steve Jones - SSC Editor

SSC Guru

Points: 736173
More actions
December 12, 2019 at 12:00 am

#3700796

Comments posted to this topic are about the item The Mangled Outer Join

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

Stewart "Arturius" Campbell SSC Guru Points: 72624 More actions · Answer 1

Nice, easy back-to-basic question, thanks Steve

____________________________________________
Space, the final frontier? not any more...
All limits henceforth are self-imposed.
“libera tute vulgaris ex”

Saurabh.D Ten Centuries Points: 1164 More actions · Answer 2

Execution plan changes with column in WHERE clause but physical join type remains the same.

ThanksSaurabh.D

ralm Hall of Fame Points: 3156 More actions · Answer 3

Alias name confused and mind thought it should be right join 🙂

^{[font="Verdana"]Regards,
Rals[/font].}