gheinze (12/18/2012)

---

Hi all,

I search a lot for this issue but I can't realize what happen.

The case is, randomly (no very often, but last two weeks happend) we experiment problems with performance in one particulary index (dont know if there are more)

We can see the performance issue becuase the query using the index is too slow (the table has 25 millon rows)

The problem solves when we re-create the index, but i dont certally know if this is a problem of index corruption.

For some reason we dont update statics (a month ago was last time)-

We use SQL 2008 sp3

1 - Could this be the reason of the index problem?

2 - Is there any way to check why the query is to slow?

Thanks for any help

greetings from argentina!!