Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Index was not longer optimized
Message
 
 
À
06/04/2010 14:41:31
Information générale
Forum:
Microsoft SQL Server
Catégorie:
Autre
Versions des environnements
SQL Server:
SQL Server 2008
Application:
Web
Divers
Thread ID:
01458951
Message ID:
01459022
Vues:
23
>>So, what plans did you get when you tried both suggestions? Can you post them here?
>
>I haven't change anything. Because this index is constantly being changed, it seems this can corrupt the index from time to time. So, I only executed the reindex on that index today and that resolves the issue. I will check it on an occasional basis. Maybe this was caused by a one timer or else. So, we'll see.

Too bad - I was interested in the execution plans and the speed test difference. Can you at least run both statements in SSMS and check actual execution plans to see if distribution is equal (50/50) or not?
If it's not broken, fix it until it is.


My Blog
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform