>>Have you tried something like
>>
>>
UPDATE SET Fields = ?mValue WHERE Field2 = ?SomeLowSelectiveValue AND Field3 = ?SomeHighSelectiveValue
>>
>>And then sometime after it
>>
>>
UPDATE SET Fields = ?mValue WHERE Field2 = ?SomeHighSelectiveValue AND Field3 = ?SomeLowSelectiveValue
>>
>>You migh get a nasty surprise by the second statement to seem hanging. If we only could give a hint that the second needs to recompile its execution plan, I would always use parameters, but unfortunately, sometimes hardcoding makes some sense.
>>
>Hi Walter,
>
>SQL 2005 and later has RECOMPILE query hint similar to stored procedures WITH RECOMPILE option..
Thanks sergey... I almost forgot that one... Unfrtunately I support a lot of SQL2000 installations