Updated on 2024-05-07 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 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.