That's not luck, it would absolutely produce a new plan because the text changed. Even adding a space or making a letter upper case will generate a new plan.
Yes, this is correct.
I should've been more clear that moving clause from where to join does not add any performance on its own, new forcefully generated plan did. Thanks for bringing this up!
We're a place where coders share, stay up-to-date and grow their careers.
We strive for transparency and don't collect excess data.