Purpose
The USER_IND_SUBPARTITIONS view displays all index subpartitions owned by the current user in the database. This view does not have the INDEX_OWNER column compared with the DBA_IND_SUBPARTITIONS and ALL_IND_SUBPARTITIONS views.
Applicability
This topic applies only to OceanBase Database Enterprise Edition. OceanBase Database Community Edition provides only the MySQL mode.
Related views
DBA_IND_SUBPARTITIONSALL_IND_SUBPARTITIONS
Columns
| Column | Type | Nullable? | Description |
|---|---|---|---|
| INDEX_NAME | VARCHAR2(128) | NO | The name of the index. |
| PARTITION_NAME | VARCHAR2(128) | NO | The name of the partition. |
| SUBPARTITION_NAME | VARCHAR2(128) | NO | The name of the subpartition. |
| HIGH_VALUE | VARCHAR2(1024) | NO | The expression for the value bound with the subpartition. |
| HIGH_VALUE_LENGTH | NUMBER | NO | The length of the expression for the value bound with the subpartition. |
| SUBPARTITION_POSITION | NUMBER | NO | The position of a subpartition in a partition. |
| STATUS | VARCHAR2(8) | NO | Indicates whether the index partition is usable. |
| TABLESPACE_NAME | VARCHAR2(30) | NO | The name of the tablespace that contains the partition. |
| PCT_FREE | NUMBER | NO | The minimum percentage of available space in a block. At present, this column is not supported and is NULL by default. |
| INI_TRANS | NUMBER | NO | The initial number of transactions. At present, this column is not supported and is NULL by default. |
| MAX_TRANS | NUMBER | NO | The maximum number of transactions. At present, this column is not supported and is NULL by default. |
| INITIAL_EXTENT | NUMBER | NO | The size of the initial extent, in the unit of bytes. At present, this column is not supported and is NULL by default. |
| NEXT_EXTENT | NUMBER | NO | The size of secondary extents, in the unit of bytes. At present, this column is not supported and is NULL by default. |
| MIN_EXTENT | NUMBER | NO | The minimum number of extents allowed in the segment. At present, this column is not supported and is NULL by default. |
| MAX_EXTENT | NUMBER | NO | The maximum number of extents allowed in the segment. At present, this column is not supported and is NULL by default. |
| MAX_SIZE | NUMBER | NO | The maximum number of blocks allowed in the segment. At present, this column is not supported and is NULL by default. |
| PCT_INCREASE | NUMBER | NO | The percentage increase in the extent size. At present, this column is not supported and is NULL by default. |
| FREELISTS | NUMBER | NO | The number of process freelists that are allocated in the segment. At present, this column is not supported and is NULL by default. |
| FREELIST_GROUPS | NUMBER | NO | The number of process freelist groups that are allocated in the segment. At present, this column is not supported and is NULL by default. |
| LOGGING | VARCHAR2(7) | NO | Indicates whether logs are recorded for changes to the index. At present, this column is not supported and is NULL by default. |
| COMPRESSION | VARCHAR2(8) | NO | Indicates whether compression is enabled for the partitioned index. Valid values: ENABLEDISABLE |
| BLEVEL | NUMBER | NO | The B-tree level, that is, the depth of the index from its root block to its leaf blocks. A depth of 0 indicates that the root block and the leaf blocks are the same. At present, this column is not supported and is NULL by default. |
| LEAF_BLOCKS | NUMBER | NO | The number of leaf blocks in the index. At present, this column is not supported and is NULL by default. |
| DISTINCT_KEYS | NUMBER | NO | The number of distinct keys in the index partition. At present, this column is not supported and is NULL by default. |
| AVG_LEAF_BLOCKS_PER_KEY | NUMBER | NO | The average number of leaf blocks in which each distinct value in the index appears. The value is rounded to the nearest integer. The value is always 1 for indexes that enforce the UNIQUE and PRIMARY KEY constraints. At present, this column is not supported and is NULL by default. |
| AVG_DATA_BLOCKS_PER_KEY | NUMBER | NO | The average number of data blocks in the table that are pointed to by different values in the index that are rounded to the nearest integer. This statistical data is the average number of data blocks containing rows that have a specified value for the indexed columns. At present, this column is not supported and is NULL by default. |
| CLUSTERING_FACTOR | NUMBER | NO | The number of rows in the table based on the value of the index. At present, this column is not supported and is NULL by default. |
| NUM_ROWS | NUMBER | NO | The number of rows in the index subpartition. At present, this column is not supported and is NULL by default. |
| SAMPLE_SIZE | NUMBER | NO | The sample size used in analyzing this subpartition. At present, this column is not supported and is NULL by default. |
| LAST_ANALYZED | DATE | NO | The most recent date on which this partition was analyzed. At present, this column is not supported and is NULL by default. |
| BUFFER_POOL | VARCHAR2(7) | NO | The default buffer pool for the subpartition. At present, this column is not supported and is NULL by default. |
| FLASH_CACHE | VARCHAR2(7) | NO | The database smart flash cache hint for subpartition blocks. At present, this column is not supported and is NULL by default. |
| CELL_FLASH_CACHE | VARCHAR2(7) | NO | The cell flash cache hint for subpartition blocks. At present, this column is not supported and is NULL by default. |
| USER_STATS | VARCHAR2(3) | NO | Indicates whether the statistical information was directly entered by the user. At present, OceanBase Database does not support this column, and this column is NULL by default. |
| PCT_DIRECT_ACCESS | NUMBER | NO | If the index is a secondary index on an index-organized table, the value is the percentage of rows with valid guesses. At present, this column is not supported and is NULL by default. |
| GLOBAL_STATS | VARCHAR2(3) | NO | GLOBAL_STATS is YES.NO. At present, this column is not supported and is NULL by default. |
| DOMIDX_OPSTATUS | VARCHAR2(6) | NO | The status of the operation on a domain index. At present, this column is not supported and is NULL by default. |
| PARAMETERS | VARCHAR2(1000) | NO | The parameter string for a domain index. At present, this column is not supported and is NULL by default. |
| INTERVAL | VARCHAR2(3) | NO | Indicates whether the partition is in the interval section of an interval partitioned table or in the range section. The value is YES if the partition is in the interval section, and it is NO if the partition is in the range section. At present, this column is not supported and is NULL by default. |
| SEGMENT_CREATED | VARCHAR2(3) | NO | Indicates whether the index subpartition segment has been created. The value N/A indicates that the index is not subpartitioned. At present, this column is not supported and is NULL by default. |
