Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
SP takes longer than batch version
Message
De
27/01/2006 16:54:36
 
Information générale
Forum:
Microsoft SQL Server
Catégorie:
Stored procedures, Triggers, UDFs
Versions des environnements
SQL Server:
SQL Server 2000
Divers
Thread ID:
01090888
Message ID:
01091097
Vues:
19
>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
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform