Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
SP takes longer than batch version
Message
From
27/01/2006 10:44:01
Fabio Lunardon
Lunacom
Marostica, Italy
 
General information
Forum:
Microsoft SQL Server
Category:
Stored procedures, Triggers, UDFs
Title:
Re: SP takes longer than batch version
Environment versions
SQL Server:
SQL Server 2000
Miscellaneous
Thread ID:
01090888
Message ID:
01090928
Views:
13
>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.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform