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.
[ Top of Page |
Table of Contents |
Glossary |
Index ]
[ DB2 List of Books |
Search the DB2 Books ]