>Because execution plans of SQL statements that are using parameters are stored in the execution plan cache and used everytime it is called regardless of the contents of the parameter.. those without are not and will generate a new execution plan for every diffrent parameter.

Thanks