yes (and maybe no ).

Generally in my experiance yes. passing SQL with variables (or calling procedures and passing it varialbes) will be more efficient than just hitting the database with SQL containing literals.

This kind of explains it

I'm sure there are hundreds of other reasons that my tiny mind doesn't grasp