Prune advised indexes

Pruning advised indexes removes advised indexes for tables that no longer exist.

  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 -> Prune Advised Indexes.