SP takes longer than batch version

Plateforme Level Extreme

Abonnement

Profil corporatif

Produits & Services

Support

Légal

English

SP takes longer than batch version

Message

27/01/2006 10:44:01

Fabio Lunardon
Lunacom
Marostica, Italie

27/01/2006 10:29:11

Richard Hamm
State of Florida
Tallahassee, Floride, États-Unis

Information générale

Forum:

Microsoft SQL Server

Catégorie:

Stored procedures, Triggers, UDFs

Titre:

Re: SP takes longer than batch version

Versions des environnements

SQL Server:

SQL Server 2000

Divers

Thread ID:

01090888

Message ID:

01090928

Vues:

>Still at 2:40+
>
I think that the SQL optimizer doesn't succeed in correctly seeing the context of the sp.
If you want, try to post the sp syntax and the two plans in text tree syntax.

Répondre

Fil

Voir

Click here to load this message in the networking platform