Displays optimizer statistics for all indexes in the database collected using the DBMS_STATS package
Columns
___________________________
OWNER
Username of the owner of the index
INDEX_NAME
Name of the index
TABLE_OWNER
Owner of the indexed object
TABLE_NAME
Name of the indexed object
OBJECT_TYPE
Type of the indexed object
PARTITION_NAME
PARTITION_POSITION
SUBPARTITION_NAME
SUBPARTITION_POSITION
BLEVEL
LEAF_BLOCKS
DISTINCT_KEYS
AVG_LEAF_BLOCKS_PER_KEY
AVG_DATA_BLOCKS_PER_KEY
CLUSTERING_FACTOR
NUM_ROWS
AVG_CACHED_BLOCKS
AVG_CACHE_HIT_RATIO
SAMPLE_SIZE
LAST_ANALYZED
GLOBAL_STATS
USER_STATS
Related