One more thing about this error, that is really really annoying.
The ERROR message itself recommends: "Delete INDEX and recreate". As though this is possible and one can actually do that!!!.
When I tell my customers, with this error, we are at the end of the road and they need to restore from TAPE backup, the customer always asks, WHY don't you do as the message says; DELETE the Index and recreate it?....
So, I look like a fool, and they lose a day's work.
This has happened more than a few time... I am now actually trapping that error message and removing the "Recommendation" portion of it!