USER_IND_PARTITIONS¶
USER_IND_PARTITIONS displays information about index partitions accessible to the current user.
Name | Type | Description |
|---|---|---|
index_owner | character varying(64) | Name of the owner of the partitioned index to which the index partition belongs |
schema | character varying(64) | Schema of the partitioned index to which the index partition belongs |
index_name | character varying(64) | Index name of the partitioned table to which the index partition belongs |
partition_name | character varying(64) | Name of the index partition |
index_partition_usable | boolean | Whether the index partition is available |
high_value | text | Boundary of the table partition corresponding to the index partition. For a range partition, the boundary is the upper boundary. For a list partition, the boundary is the boundary value set. Reserved field for forward compatibility. The parameter pretty_high_value is added in version 8.1.3 to record the information. |
pretty_high_value | text | Boundary of the table partition corresponding to the index partition. For a range partition, the boundary is the upper boundary. For a list partition, the boundary is the boundary value set. The query result is the instant decompilation output of the partition boundary expression. The output of this column is more detailed than that of high_value. The output information can be collation and column data type. |
def_tablespace_name | name | Tablespace name of the index partition |