Condensing index advice

Many times, the index advisor advises several different indexes for the same table. You can condense these advised indexes into the best matches for your queries.

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

Depending on if you are viewing the condensed index advice at the database level or the schema level your list could be large. Once you have the list displayed, follow these steps to subset your list:

  1. Go to the View menu option, and select Customize this view > Include ...
  2. Enter the information you would like to filter the list by.
  3. Select OK to get the refreshed list of condensed index advice.
System i Navigator - Index Advisor - Condensed Index Advice