RelationalDBDesign RelationalDBDesign 


Data Blocks  «Prev

Oracle Index Statistics

Oracle lists the following index statistics in the DBA_INDEXES, USER_INDEXES, and ALL_INDEXES data dictionary views:
  1. Exact depth of the index from root block to leaf blocks
  2. Number of leaf blocks
  3. Clustering factor (the order of the rows in relation to indexed values)
  4. Number of distinct index values
  5. Average number of leaf blocks per index value
  6. Average number of data blocks per index value (for an index on a table)