The Health display in the Database Alert Monitor and liveCache Alert Monitor gives you information on bad indexes.
Open the Database Alert Monitor or liveCache Alert Monitor. Choose .
Number of Bad Indexes
Yellow alert: The monitor could not determine the number of bad database indexes.
Red alert: Bad database indexes exist.