DBA_IND_STATISTICS

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

DBA_INDEXES

 


© Copyright SS64.com 1999-2014
Some rights reserved