Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Index was not longer optimized
Message
 
 
To
06/04/2010 14:41:31
General information
Forum:
Microsoft SQL Server
Category:
Other
Environment versions
SQL Server:
SQL Server 2008
Application:
Web
Miscellaneous
Thread ID:
01458951
Message ID:
01459022
Views:
22
>>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
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform