Feature
ALL_IND_STATISTICS displays the optimizer statistics of indexes on tables accessible to the current user.
Applicability
This topic applies only to OceanBase Database Enterprise Edition. OceanBase Database Community Edition provides only MySQL mode.
Fields
| Field | Type | Nullable | Description |
|---|---|---|---|
| OWNER | VARCHAR2(128) | NO | The owner of the index. |
| INDEX_NAME | VARCHAR2(128) | NO | The name of the index. |
| TABLE_OWNER | VARCHAR2(128) | NO | The owner of the index object. |
| TABLE_NAME | VARCHAR2(128) | NO | The name of the index object. |
| PARTITION_NAME | VARCHAR2(128) | NO | The name of the partition. |
| PARTITION_POSITION | NUMBER | NO | The position of the partition within the index. |
| SUBPARTITION_NAME | VARCHAR2(128) | NO | The name of the subpartition. |
| SUBPARTITION_POSITION | NUMBER | NO | The position of the subpartition in the partition. |
| OBJECT_TYPE | VARCHAR2(12) | NO | The type of the object. Valid values:INDEXPARTITIONSUBPARTITION |
| BLEVEL | NUMBER | NO | The B-Tree level. |
| LEAF_BLOCKS | NUMBER | NO | The number of leaf blocks in the index. |
| DISTINCT_KEYS | NUMBER | NO | The number of distinct keys in the index. |
| AVG_LEAF_BLOCKS_PER_KEY | NUMBER | NO | The average number of leaf blocks per key. |
| AVG_DATA_BLOCKS_PER_KEY | NUMBER | NO | The average number of data blocks per key. |
| CLUSTERING_FACTOR | NUMBER | NO | The sequential characteristics of rows in the table based on the value of the index. |
| NUM_ROWS | NUMBER | NO | The number of rows in the index. |
| AVG_CACHED_BLOCKS | NUMBER | NO | The average number of blocks in the buffer cache. |
| AVG_CACHE_HIT_RATIO | NUMBER | NO | The average cache hit rate of the object. |
| SAMPLE_SIZE | NUMBER | NO | The sample size used for index analysis. |
| LAST_ANALYZED | DATE | NO | The date on which the index was analyzed the last time. |
| GLOBAL_STATS | VARCHAR2(3) | NO | Indicates whether the statistics are collected or incrementally maintained. Valid values:YESNO |
| USER_STATS | VARCHAR2(3) | NO | Indicates whether the statistics are directly entered by the user. Valid values:YESNO |
| STATTYPE_LOCKED | VARCHAR2(5) | NO | The type of the statistics lock. |
| STALE_STATS | VARCHAR2(3) | NO | Indicates whether the statistics of the object are stale. |
| SCOPE | VARCHAR2(7) | NO | Indicates whether statistics are collected from any table other than global temporary tables. For global temporary tables, the value can be: SESSION: indicates that the statistics are session-specific.SHARED: indicates that statistics are shared across all sessions. |