Usage

<< Click to Display Table of Contents >>

Navigation:  Index Usage >

Usage

Index Usage

 

 

1.Index data aggregated to database level

2.Index data aggregated to table level

3.Index data. If the index is partitioned then the data is aggregated to the index.

 

indexusagetree

 

 

 

Grid Bands

there are 6 grid bands

 

1.Index- the tree

2.Index Details- details about the table and index

3.Users Summary- Aggregates all user read operations on counts and last date. It also include user read/write ratio to show the how the index is used.

4.User Details- detailed information of index usage by user

5.System Summary-Aggregates all system read operations on counts and last date. It also include user read/write ratio to show the how the index is used.

6.System Details- detailed information of index usage by system