Chand Basha

• Jan 3rd, 2007

 

It increase the load on server. if other applications are using same DB server, they become solw.

Chand.

Guest

• Jan 9th, 2007

 

It is possible that the statistics have changed since a stored procedure was compiled and thus may be executing a less the optimal executionplan, thus it may run slower.

anjan_maity

 Profile Answers by anjan_maity 

• Aug 7th, 2008

 

When a procedure is created a execution plan is created, proc is executed according to that execution plan. When we modify the proc it also follow this execution plan.
When index is rebuild, new index structure is created, but the proc follows the old execution plan because it was compiled, so there is a chance of unexpected result.
For this there is need to recompile the proc.