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

csaba.trucza@gmail.com

2006-03-31, 7:24 am

Hi Wayne,

> Look at using the "WITH RECOMPILE" option when creating or running your procedure
> and see if that keeps the performance stable.

As reproducong the original situation is not as simple as I'd like to,
I still have to wait and see if we get into trouble with the WITH
RECOMPILE option.

In some troublesome procedures I included the WITH RECOMPILE option, in
others I included WITH(INDEX(...)) hints.

Now I'm waiting to see if any of them start behaving badly.

I observed though that WITH RECOMPILE slows down the execution a little
bit.

OTOH it will always produce optimized execution plans. Right?

Greetings,
Csaba

Sponsored Links