>>>Thanks!
>>>
>>>I can't attach it here and neither can I post it even though I surround it with pre tags. :(
>>
>>Frank,
>>ZIP the .SQLPLAN and attach it as a file here.
>
>See attached.

That looks like the estimated executionplan as its missing the actual numbers. Can you post the performed execution plan?

Can you also execute it with the RECOMPILE option? Depending on the parameters passed it might reuse an execution plan that is optimal for one value, but not for another.


Walter,