MY_IND_SUBPARTITIONS
MY_IND_SUBPARTITIONS displays the partition information about local indexes of level-2 partitioned table owned by the current user (excluding global indexes of partitioned tables). It is accessible to all users. This view exists in both PG_CATALOG and SYS schema. The distributed system does not support level-2 partitions. Currently, all columns in this table are set to NULL.
| Name | Type | Description |
|---|---|---|
| index_owner | character varying(128) | Not supported. Its value is NULL. |
| index_name | character varying(128) | Not supported. Its value is NULL. |
| partition_name | character varying(128) | Not supported. Its value is NULL. |
| subpartition_name | character varying(128) | Not supported. Its value is NULL. |
| high_value | text | Not supported. Its value is NULL. |
| high_value_length | numeric | Not supported. Its value is NULL. |
| partition_position | numeric | Not supported. Its value is NULL. |
| subpartition_position | numeric | Not supported. Its value is NULL. |
| status | character varying(8) | Not supported. Its value is NULL. |
| tablespace_name | character varying(30) | Not supported. Its value is NULL. |
| pct_free | numeric | Not supported. Its value is NULL. |
| ini_trans | numeric | Not supported. Its value is NULL. |
| max_trans | numeric | Not supported. Its value is NULL. |
| initial_extent | numeric | Not supported. Its value is NULL. |
| next_extent | numeric | Not supported. Its value is NULL. |
| min_extent | numeric | Not supported. Its value is NULL. |
| max_extent | numeric | Not supported. Its value is NULL. |
| max_size | numeric | Not supported. Its value is NULL. |
| pct_increase | numeric | Not supported. Its value is NULL. |
| freelists | numeric | Not supported. Its value is NULL. |
| freelist_groups | numeric | Not supported. Its value is NULL. |
| logging | character varying(7) | Not supported. Its value is NULL. |
| compression | character varying(13) | Not supported. Its value is NULL. |
| blevel | numeric | Not supported. Its value is NULL. |
| leaf_blocks | numeric | Not supported. Its value is NULL. |
| distinct_keys | numeric | Not supported. Its value is NULL. |
| avg_leaf_blocks_per_key | numeric | Not supported. Its value is NULL. |
| avg_data_blocks_per_key | numeric | Not supported. Its value is NULL. |
| clustering_factor | numeric | Not supported. Its value is NULL. |
| num_rows | numeric | Not supported. Its value is NULL. |
| sample_size | numeric | Not supported. Its value is NULL. |
| last_analyzed | date | Not supported. Its value is NULL. |
| buffer_pool | character varying(7) | Not supported. Its value is NULL. |
| flash_cache | character varying(7) | Not supported. Its value is NULL. |
| cell_flash_cache | character varying(7) | Not supported. Its value is NULL. |
| user_stats | character varying(3) | Not supported. Its value is NULL. |
| global_stats | character varying(3) | Not supported. Its value is NULL. |
| interval | character varying(3) | Not supported. Its value is NULL. |
| segment_created | character varying(3) | Not supported. Its value is NULL. |
| domidx_opstatus | character varying(6) | Not supported. Its value is NULL. |
| parameters | character varying(1000) | Not supported. Its value is NULL. |
Feedback
Was this page helpful?
Provide feedbackThank you very much for your feedback. We will continue working to improve the documentation.
