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