Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Speed up SQL
Message
From
12/06/2013 11:24:22
 
 
To
12/06/2013 10:16:31
Walter Meester
HoogkarspelNetherlands
General information
Forum:
Microsoft SQL Server
Category:
SQL syntax
Title:
Environment versions
SQL Server:
SQL Server 2008
Application:
Desktop
Miscellaneous
Thread ID:
01576055
Message ID:
01576127
Views:
33
>>>>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
Frank.

Frank Cazabon
Samaan Systems Ltd.
www.samaansystems.com
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform