Recovering indexes

The database administrator can recover or rebuild defective indexes with the utility statement RECOVER INDEX ).

Optionally, he/she can recover or rebuild

• a specific index, specified by means of its index name,

• all indexes that belong to a specific table,

• all indexes that belong to the tables in a specific user space.