Condense advised indexes

Many times, the index advisor will advise 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.