|Subject||Re: How likely is corruption of indexes in this system ?|
> Without an alternative explanation and since the daily rebuildDid the PLAN indicate that the same index was used for both the select
> prevents the problem I still have to assume corruption is the cause
> and continue with the rebuilds.
and the update? If so, a corrupted index would not have caused it. If
(in your test environment), you slightly manipulated the queries so
the no indices are used (eg, add +0 to the fields in the where
clause), are the row counts still wrong?
Do you have any update triggers that might (directly or indirectly)
deleting or inserting records thus effecting the counts?