MS SQL Server - Re: Different execution plans from c# code and MSSQLServerManageme

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]

Author

Re: Different execution plans from c# code and MSSQLServerManageme

Wayne

2006-03-30, 7:23 am

As Uri notes the execution plan may still be reused and depending on the
WHERE clause you build may not be optimal. Look at using the "WITH
RECOMPILE" option when creating or running your procedure and see if that
keeps the performance stable.

"Uri Dimant" wrote:

> Hi
>
> No, SQL Server could resuse an execution plan otherwise we would have seen
> RECOMPILE statement in Profiler
>
> Well , there are many scenarios that make hurt perfomance as we know as
> "parameter sniffing"
> Search on interenet for this tiltle to get more details as well please read
> this article may shed some lights on.
>
> http://www.sql-server-performance.com/q&a132.asp
> http://www.sql-server-performance.c...n
ing.asp
>
>
>
> <csaba.trucza@gmail.com> wrote in message
> news:1143715907.378509.198330@j33g2000cwa.googlegroups.com...
>
>
>

Sponsored Links