Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Optimizing delete SQL
Message
From
17/02/2011 12:38:43
 
 
To
17/02/2011 12:22:49
General information
Forum:
Microsoft SQL Server
Category:
SQL syntax
Environment versions
SQL Server:
SQL Server 2008
Application:
Web
Miscellaneous
Thread ID:
01500559
Message ID:
01500565
Views:
38
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.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform