[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | INDEX_STATS |
|---|---|
| Object Type: | VIEW |
| Owner: | SYS |
| Subobject Name: | |
| Status: | VALID |
statistics on the b-tree
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| HEIGHT | NUMBER | height of the b-tree | ||
| BLOCKS | NUMBER | blocks allocated to the segment | ||
| NAME | VARCHAR2 | (128) | name of the index | |
| PARTITION_NAME | VARCHAR2 | (128) | name of the index partition, if partitioned | |
| LF_ROWS | NUMBER | number of leaf rows (values in the index) | ||
| LF_BLKS | NUMBER | number of leaf blocks in the b-tree | ||
| LF_ROWS_LEN | NUMBER | sum of the lengths of all the leaf rows | ||
| LF_BLK_LEN | NUMBER | useable space in a leaf block | ||
| BR_ROWS | NUMBER | number of branch rows | ||
| BR_BLKS | NUMBER | number of branch blocks in the b-tree | ||
| BR_ROWS_LEN | NUMBER | sum of the lengths of all the branch blocks in the b-tree | ||
| BR_BLK_LEN | NUMBER | useable 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 | ||
| MOST_REPEATED_KEY | NUMBER | how many times the most repeated key is repeated | ||
| BTREE_SPACE | NUMBER | total space currently allocated in the b-tree | ||
| USED_SPACE | NUMBER | total space that is currently being used in the b-tree | ||
| PCT_USED | NUMBER | percent of space allocated in the b-tree that is being used | ||
| ROWS_PER_KEY | NUMBER | average number of rows per distinct key | ||
| BLKS_GETS_PER_ACCESS | NUMBER | Expected number of consistent mode block gets per row. This assumes that a row chosen at random from the table is being searched for using the index | ||
| 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 prefix compression count for the index | ||
| OPT_CMPR_PCTSAVE | NUMBER | percentage storage saving expected from optimal prefix compression |
Cut, paste (and edit) the following text to query this object:
SELECT HEIGHT
, 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
, MOST_REPEATED_KEY
, BTREE_SPACE
, USED_SPACE
, PCT_USED
, ROWS_PER_KEY
, BLKS_GETS_PER_ACCESS
, PRE_ROWS
, PRE_ROWS_LEN
, OPT_CMPR_COUNT
, OPT_CMPR_PCTSAVE
FROM SYS.INDEX_STATS;
SYS
IND$
INDPART$
INDSUBPART$
OBJ$
SEG$
PUBLIC
INDEX_STATS
|
|
|
|