Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Optimizing delete SQL
Message
De
17/02/2011 14:06:37
 
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:
01500586
Vues:
44
>As I saw from the Execution plat the most part of the operation if for recreating the clustered index.
>Could you try to remove the index first then DELETE and then recreate it?

Could it be that the index become bloated?

I recreated them all and the execution plan is showing something brand new, well scaled, with low numbers. So, it seems because that table is receiving new records every second, and that we do a regular maintenance on the Hit table that it was time to reindex everything. I always thought SQL Server was more robust in that direction. I will see, once we reindex on the production, if that helps.

The table I made the test on has 809796 records.
Michel Fournier
Level Extreme Inc.
Designer, architect, owner of the Level Extreme Platform
Subscribe to the site at https://www.levelextreme.com/Home/DataEntry?Activator=55&NoStore=303
Subscription benefits https://www.levelextreme.com/Home/ViewPage?Activator=7&ID=52
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform