INDEX_STATS stores information from the last ANALYZE INDEX ... VALIDATE STRUCTURE statement.
The ANALYZE INDEX ... VALIDATE STRUCTURE OFFLINE statement must be used in order to collect statistics
| Column | Datatype | NULL | Description |
|
|
| | Height of the B-Tree |
|
|
|
| Blocks allocated to the segment |
|
|
|
| Name of the index |
|
|
| | Name of the partition of the index which was analyzed. If the index is not partitioned, null is returned. |
|
|
| | Number of leaf rows (values in the index) |
|
|
| | Number of leaf blocks in the B-Tree |
|
|
| | Sum of the lengths of all the leaf rows |
|
|
| | Usable space in a leaf block |
|
|
| | Number of branch rows in the B-Tree |
|
|
| | Number of branch blocks in the B-Tree |
|
|
| | Sum of the lengths of all the branch blocks in the B-Tree |
|
|
| | Usable space in a branch block |
|
|
| | Number of deleted leaf rows in the index |
|
|
| | Total length of all deleted rows in the index |
|
|
| | Number of distinct keys in the index (may include rows that have been deleted) |
|
|
| | How many times the most repeated key is repeated (may include rows that have been deleted) |
|
|
| | Total space currently allocated in the B-Tree |
|
|
| | Total space that is currently being used in the B-Tree |
|
|
| | Percent of space allocated in the B-Tree that is being used |
|
|
| | Average number of rows per distinct key (this figure is calculated without consideration of deleted rows) |
|
|
| | 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. |
|
|
| | Number of prefix rows (values in the index) |
|
|
| | Sum of lengths of all prefix rows |
|
|
| | Optimal key compression length |
|
|
| | Corresponding space savings after an |
No comments:
Post a Comment