Drop Table
Support Forum for database administrators and web based access to important newsgroups related to databases
sp_recompileI have a stored procedure that is currently using a poor execution plan. SP_recompile marks the plan for recompile, but is not changing the plan afte r execution. Dropping and re-creating the stored procedure does modify the plan to use a much more effiecient plan. Any thoughts?
Post Follow-up to this message
Re: sp_recompiledoes it make any difference if you do: exec <your_sp> with recompile -- -oj "Brandon" <Brandon@discussions.microsoft.com> wrote in message news:F51DCB0A-5CD5-4CEB-9649- 117E6A4E2C1D@microso ft.com... >I have a stored procedure that is currently using a poor execution plan. > SP_recompile marks the plan for recompile, but is not changing the plan > after > execution. Dropping and re-creating the stored procedure does modify the > plan to use a much more effiecient plan. Any thoughts? >
Post Follow-up to this message Re: sp_recompileNo. In addition, I have tried to clear the proc cache for the given database: DBCC FLUSHPROCINDB (<my_db> ). "oj" wrote: > does it make any difference if you do: > exec <your_sp> with recompile > > > > -- > -oj > > > > "Brandon" <Brandon@discussions.microsoft.com> wrote in message > news:F51DCB0A-5CD5-4CEB-9649- 117E6A4E2C1D@microso ft.com... > > >
Post Follow-up to this message
Sponsored Links
Show a Printable Version
Email This Page to Someone!
Receive updates to this thread
