Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
SP takes longer than batch version
Message
From
27/01/2006 16:54:36
 
General information
Forum:
Microsoft SQL Server
Category:
Stored procedures, Triggers, UDFs
Environment versions
SQL Server:
SQL Server 2000
Miscellaneous
Thread ID:
01090888
Message ID:
01091097
Views:
21
>Yep, it said to take nearly all the indexes off (except the primary). That put me back at the 2:30 mark. I placed the index that we've been talking about and the batch at least works as I said.
>
>Something just ain't right...
>
>Richard
>

Richard,
to words I would not know what other to tell you, would need to hold the database.

It could be also a bug of the optimizer.

Hi.

Fabio
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform