Clear advised indexes
Clearing advised indexes removes all indexes from the Index advisor table.
- 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 -> Clear Advised Indexes.