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