Purpose
The ALL_IND_STATISTICS view displays the optimizer statistics on the indexes of tables accessible to the current user.
Applicability
This view applies only to OceanBase Database Enterprise Edition. OceanBase Database Community Edition provides only the MySQL mode.
Columns
| Column | 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 within the partition. |
| OBJECT_TYPE | VARCHAR2(12) | NO | The type of the object. Valid values: |
| BLEVEL | NUMBER | NO | The value of this column is NULL by default. |
| LEAF_BLOCKS | NUMBER | NO | The value of this column is NULL by default. |
| DISTINCT_KEYS | NUMBER | NO | The value of this column is NULL by default. |
| AVG_LEAF_BLOCKS_PER_KEY | NUMBER | NO | The value of this column is NULL by default. |
| AVG_DATA_BLOCKS_PER_KEY | NUMBER | NO | The value of this column is NULL by default. |
| CLUSTERING_FACTOR | NUMBER | NO | The value of this column is NULL by default. |
| NUM_ROWS | NUMBER | NO | The number of rows in the index. |
| AVG_CACHED_BLOCKS | NUMBER | NO | The value of this column is NULL by default. |
| AVG_CACHE_HIT_RATIO | NUMBER | NO | The value of this column is NULL by default. |
| SAMPLE_SIZE | NUMBER | NO | The value of this column is NULL by default. |
| LAST_ANALYZED | DATE | NO | The date on which the index was last analyzed. |
| GLOBAL_STATS | VARCHAR2(3) | NO | Indicates whether the statistics are collected or incrementally maintained. Valid values: |
| USER_STATS | VARCHAR2(3) | NO | Indicates whether the statistics are directly entered by the user. Valid values: |
| 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 | The value of this column is NULL by default. |