Display the Index Advisor

To display the index advisor:

  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 -> Index Advisor.

You can clear the list of advised indexes, condense the indexes for a single table, or remove the advised indexes for a table that no longer exists.

For details about the columns displayed, see Columns for Index Advisor.