Subject How likely is corruption of indexes in this system ?
Author Matt Clark
We have a heavily indexed (18 fields in 10 indexes) table on fb1.5
with 32mil records and approx 35k being added throughout the day. Can
anyone comment on the likelyhood of the indexes being corrupted within
a day due to that volume of data being added ?

I ask because a while ago we were able to confirm that at the end of a
day trading a select and an update with the same criteria would return
a different rowcount! Since then we've had a program of rebuilding
loads of indexes daily and that seems to be controlling the problem
but it's getting to a point where this is not practical so ideally I
want to stop rebuilding the indexes daily. I'm doing several things to
reduce the dependency on these indexes but ultimately if I can't
explain the symptoms described I'm not going to be able to disable the
rebuild on whatever indexes remain.
Does it sound like index corruption or can you suggest another reason
we might be getting the symptoms described ?

regards,
Matt