Updated on 2024-06-03 GMT+08:00

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.