Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Speed up SQL
Message
De
12/06/2013 11:24:22
 
 
À
12/06/2013 10:16:31
Walter Meester
HoogkarspelPays-Bas
Information générale
Forum:
Microsoft SQL Server
Catégorie:
Syntaxe SQL
Titre:
Versions des environnements
SQL Server:
SQL Server 2008
Application:
Desktop
Divers
Thread ID:
01576055
Message ID:
01576127
Vues:
35
>>>>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
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform