Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Optimizing delete SQL
Message
De
17/02/2011 12:38:43
 
 
À
17/02/2011 12:22:49
Information générale
Forum:
Microsoft SQL Server
Catégorie:
Syntaxe SQL
Versions des environnements
SQL Server:
SQL Server 2008
Application:
Web
Divers
Thread ID:
01500559
Message ID:
01500565
Vues:
39
Michel, a few questions...

For the table in question....are there indexes and/or relation/constraints involved, and/or any delete triggers?

Also, have you looked at the execution plan?

There are different possible optoins....if the table has an ID you can use (for the IDs to be deleted), if you're passing them in the same order as the original table (if you're using a clustered index), you may get more cache hits.
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform