How the index is used is broken down into
•Usage- provide information from the perspective of the index itself
•Operations- provides information from the perspective of the index b-tree level
•In Memory- memory usage by object and index
Index Usage and operations information
Both are displayed with a Tree and a Grid tab.
•Grid- shows a single row for each index (partitioned indexes) are aggregated
•Tree shows the same information as the grid with additional rows aggregated to table and instance level.
The grid and the tree are banded