>I found a situation today where a query was slow. The execution plan was not using the index has it should. This is an index which is composed by several fields. The number of fields is two. So, this is a very simple index with two fields. A query to return five records took 31 seconds. So, I looked at the execution plan and saw that it was not using it. I generated the script to recreate that index. After that, the execution plan showed that it was using it and the query was immediate.
>
>Is this some kind of index corruption?
Take a look at the thread with the same problem in MSDN forum
http://social.msdn.microsoft.com/Forums/en-US/sqldatabaseengine/thread/e14518c0-0d93-4fc2-ac16-146b3de93d4b
If it's not broken, fix it until it is.
My Blog