Hi,
you can analyze the indexes on the table like this
ANALYZE INDEX indexname COMPUTE STATISTICS;
If the index is corrupt it will show up the same way as it did after the analyze table command.
I think all your indexes wil have to be rebuilded but I'm not sure.
Greetings,
Tycho




Reply With Quote