Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Sun Foster
Aged Yak Warrior
515 Posts |
 Posted - 2006-11-09 : 10:22:43
|
| Do we need to re-compile store procedure?A SQL admin guy want me do it. I am confused. |
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2006-11-09 : 10:24:45
|
if your sproc uses a non optimal execution plan then it's a good thing to recomplie it.Go with the flow & have fun! Else fight the flow  blog thingie: http://weblogs.sqlteam.com/mladenp |
 |
|
|
Kristen
Test
22859 Posts |
Posted - 2006-11-10 : 04:24:11
|
| Or if the "shape" of the index is changing, and the cached-query plan that the SProc has is now inefficient. You might choose to mark such SProcs for recompile as part of a once-a-day task, for example.Or stop-start the SQL Server which will freshen the whole lot!Kristen |
|
|
|
|
|
|
re-compile store procedure