>>>>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,
I've attached the Actual Execution Plan.
Will research the RECOMPILE option and try it out.
Thanks