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
