Let's say you have the following stored procedure:

SELECT Name FROM Person

WHERE City = @city

If you call this stored procedure for the first time, the value of @city will be used...

anil_kumar32 (7/7/2011)

---

[font="Times New Roman"]

When there are some changes in input parameters or underlying table from which SP is fetching data, store procedure is recompiled and a new execution plan is...

RECOMPILE can be very useful, if the optimal execution plan highly depends on the given parameters. As the execution plan depends on the initial parameters during first execution, this execution...