re: Improving SQL Query by Adding conditions in Joins VIEW POST

re: You were just lucky. Query optimizer has chosen a non cached version of plan to execute this query.

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!

code of conduct - report abuse