DB_IND_SUBPARTITIONS

DB_IND_SUBPARTITIONS displays partition information about local indexes of level-2 partitioned table accessible to 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 columns in this table are set to NULL.

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