Performance doesn't change even move the where condition statement to JOIN
Esc Cost took 44.0% and I have moved the where conditions statement to JOIN statement. I am getting the same result. Any comments would be really appreciatable.
Moving filter conditions between the ON clause and the WHERE clause will not change how the optimizer will produce the plan. To make a difference to the optimizer, you would have to change the ON clause or add to it.
For example, changing the the "join Rating.ElementFactor ef on ef.FactorID = f.ID" to "join Rating.ElementFactor ef on ef.FactorID = f.ID and ef.FactorID = rcf.FactorID" could possibly cause a change in your plan.