Running CHECK INDEX after loading a table that has indexes
The CHECK INDEX utility tests whether an index is consistent with the data it indexes and issues error messages if it finds an inconsistency.
About this task
Procedure
To check the accuracy of the index:
Invoke the CHECK INDEX utility. You might also
want to invoke the CHECK INDEX utility after any LOAD operation that
shows some abnormal condition in its execution, or even run it periodically
to verify the accuracy of important indexes.