|
Home > Archive > MS SQL Server > March 2006 > sp_recompile
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
|
|
| Brandon 2006-03-29, 8:23 pm |
| 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?
| |
|
| 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...
>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?
>
| |
| Brandon 2006-03-30, 11:23 am |
| No. 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...
>
>
>
|
|
|
|
|