Clear advised indexes

Clearing advised indexes removes all indexes from the Index advisor table.

  1. In the System i Navigator window, expand the system you want to use.
  2. Expand Databases.
  3. Right-click the database that you want to work with and select Index Advisor -> Clear Advised Indexes.