Prune advised indexes
Pruning advised indexes removes advised indexes for tables that no longer exist.
- In the System i Navigator window, expand the system you want to use.
- Expand Databases.
- Right-click the database that you want to work with and select Index Advisor -> Prune Advised Indexes.