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.

**Table 1** MY_IND_SUBPARTITIONS columns
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.