There are two ways to display detailed statistics for an index:
- From the Access Plan Graph window, double-click on the index node in the graph, use the pop-up menu, or use
the menu selections. An Index Statistics window opens.
- From the Table Statistics window, click on the Indexes push button This displays a list of the
indexes that are currently defined and those that were defined on the table
when the explain snapshot was created. Select the indexes you want and
click on OK. An Index Statistics window
opens for each of the selected indexes.