HEIGHT 
NUMBER 

Height of the BTree 
BLOCKS 
NUMBER 
NOT NULL 
Blocks allocated to the segment 
NAME 
VARCHAR2(30) 
NOT NULL 
Name of the index 
PARTITION_NAME 
VARCHAR2(30) 

Name of the partition of the index which was analyzed. If the index is not partitioned, a NULL is returned. 
LF_ROWS 
NUMBER 

Number of leaf rows (values in the index) 
LF_BLKS 
NUMBER 

Number of leaf blocks in the BTree 
LF_ROWS_LEN 
NUMBER 

Sum of the lengths of all the leaf rows 
LF_BLK_LEN 
NUMBER 

Usable space in a leaf block 
BR_ROWS 
NUMBER 

Number of branch rows in the BTree 
BR_BLKS 
NUMBER 

Number of branch blocks in the BTree 
BR_ROWS_LEN 
NUMBER 

Sum of the lengths of all the branch blocks in the BTree 
BR_BLK_LEN 
NUMBER 

Usable space in a branch block 
DEL_LF_ROWS 
NUMBER 

Number of deleted leaf rows in the index 
DEL_LF_ROWS_LEN 
NUMBER 

Total length of all deleted rows in the index 
DISTINCT_KEYS 
NUMBER 

Number of distinct keys in the index (may include rows that have been deleted) 
MOST_REPEATED_KEY 
NUMBER 

How many times the most repeated key is repeated (may include rows that have been deleted) 
BTREE_SPACE 
NUMBER 

Total space currently allocated in the BTree 
USED_SPACE 
NUMBER 

Total space that is currently being used in the BTree 
PCT_USED 
NUMBER 

Percent of space allocated in the BTree that is being used 
ROWS_PER_KEY 
NUMBER 

Average number of rows per distinct key (this figure is calculated without consideration of deleted rows) 
BLKS_GETS_PER_ACCESS 
NUMBER 

Expected number of consistent mode block reads per row, assuming that a randomly chosen row is accessed using the index. Used to calculate the number of consistent reads that will occur during an index scan. 
PRE_ROWS 
NUMBER 

Number of prefix rows (values in the index) 
PRE_ROWS_LEN 
NUMBER 

Sum of lengths of all prefix rows 
OPT_CMPR_COUNT 
NUMBER 

Optimal key compression length 
OPT_CMPR_PCTSAVE 
NUMBER 

Corresponding space savings after an ANALYZE 