The menu option Validate > Validate Index Status checks the metadata definition of an index against that in use in the database. It checks to ensure that the index exists and that the index type and columns are the same.
The results are listed in the middle pane with the status of each selected index shown.
If an index differs, then the only option is to drop and create the index either via the scheduler or through the right-click menu options for the index.

  • No labels