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 the PG_CATALOG and SYS schemas. The distributed system does not support level-2 partitions. Currently, all fields in this table are set to NULL.

**Table 1** MY_IND_SUBPARTITIONS columns
Name	Type	Description
index_owner	character varying(128)	Not supported. Set it to NULL.
index_name	character varying(128)	Not supported. Set it to NULL.
partition_name	character varying(128)	Not supported. Set it to NULL.
subpartition_name	character varying(128)	Not supported. Set it to NULL.
high_value	text	Not supported. Set it to NULL.
high_value_length	numeric	Not supported. Set it to NULL.
partition_position	numeric	Not supported. Set it to NULL.
subpartition_position	numeric	Not supported. Set it to NULL.
status	character varying(8)	Not supported. Set it to NULL.
tablespace_name	character varying(30)	Not supported. Set it to NULL.
pct_free	numeric	Not supported. Set it to NULL.
ini_trans	numeric	Not supported. Set it to NULL.
max_trans	numeric	Not supported. Set it to NULL.
initial_extent	numeric	Not supported. Set it to NULL.
next_extent	numeric	Not supported. Set it to NULL.
min_extent	numeric	Not supported. Set it to NULL.
max_extent	numeric	Not supported. Set it to NULL.
max_size	numeric	Not supported. Set it to NULL.
pct_increase	numeric	Not supported. Set it to NULL.
freelists	numeric	Not supported. Set it to NULL.
freelist_groups	numeric	Not supported. Set it to NULL.
logging	character varying(7)	Not supported. Set it to NULL.
compression	character varying(13)	Not supported. Set it to NULL.
blevel	numeric	Not supported. Set it to NULL.
leaf_blocks	numeric	Not supported. Set it to NULL.
distinct_keys	numeric	Not supported. Set it to NULL.
avg_leaf_blocks_per_key	numeric	Not supported. Set it to NULL.
avg_data_blocks_per_key	numeric	Not supported. Set it to NULL.
clustering_factor	numeric	Not supported. Set it to NULL.
num_rows	numeric	Not supported. Set it to NULL.
sample_size	numeric	Not supported. Set it to NULL.
last_analyzed	date	Not supported. Set it to NULL.
buffer_pool	character varying(7)	Not supported. Set it to NULL.
flash_cache	character varying(7)	Not supported. Set it to NULL.
cell_flash_cache	character varying(7)	Not supported. Set it to NULL.
user_stats	character varying(3)	Not supported. Set it to NULL.
global_stats	character varying(3)	Not supported. Set it to NULL.
interval	character varying(3)	Not supported. Set it to NULL.
segment_created	character varying(3)	Not supported. Set it to NULL.
domidx_opstatus	character varying(6)	Not supported. Set it to NULL.
parameters	character varying(1000)	Not supported. Set it to NULL.