Used Indexes (iSeries)

This monitor provides an overview on Indexes which are used to execute queries that contain record selection, joins, ordering or grouping since the last IPL of the database server. Indexes are useful if you want to run the same query more often.

To display information on which indexes have been used, call transaction DB4COCKPIT.

  1. In the navigation frame, choose Performance ® Database Monitor ® Used Indexes.

The query optimizer indicates which indexes were used to implement queries (Index File)

  1. You can access information on why the indexes were used (Reason Code) by clicking the index you are interested in.

A dialog box with the corresponding information appears.

  1. For more detailed information, double-click one of the SQL statements in the dialog box.