INDEX_STATS

[gaegoori]

INDEX_STATS gives you what kinds of information? (choose TWO)

1. Distinct Keys
2. I/O level
3. Number of empty blocks
4. Index level
5. Average blocks per key
6. Number of contention blocks

[dknight]

I would say (1) and (4).

SQL> desc index_stats
Name
--------------------------
HEIGHT (4)
BLOCKS
NAME
PARTITION_NAME
LF_ROWS
LF_BLKS
LF_ROWS_LEN
LF_BLK_LEN
BR_ROWS
BR_BLKS
BR_ROWS_LEN
BR_BLK_LEN
DEL_LF_ROWS
DEL_LF_ROWS_LEN
DISTINCT_KEYS (1)
MOST_REPEATED_KEY
BTREE_SPACE
USED_SPACE
PCT_USED
ROWS_PER_KEY
BLKS_GETS_PER_ACCESS
PRE_ROWS
PRE_ROWS_LEN

[julian]

Why 1 & 4:

2. INDEX_STATS has nothing to do with I/O level
3. Number of empty blocks is a table level statistics

5. Average blocks per key is a cluster property.
6. Number of contention blocks has nothing to do with the structure of an index.