MY_INDEXES
MY_INDEXES displays index information about the current user. This view exists in both PG_CATALOG and SYS schema.
Name |
Type |
Description |
---|---|---|
owner |
character varying(64) |
Index owner. |
index_name |
character varying(64) |
Index name. |
table_name |
character varying(64) |
Name of the table corresponding to the index. |
uniqueness |
text |
Specifies whether the index is a unique index.
|
partitioned |
character(3) |
Specifies whether the index has the property of partitioned tables.
|
generated |
character varying(1) |
Specifies whether the index name is generated by the system.
|
index_type |
character varying(27) |
Index type.
|
table_owner |
character varying(128) |
Owner of an index object. |
table_type |
character(11) |
Type of the index object.
|
tablespace_name |
character varying(30) |
Name of a tablespace that contains the index. |
status |
character varying(8) |
Status of a non-partitioned index.
|
compression |
character varying(13) |
Not supported. Its value is NULL. |
prefix_length |
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_extents |
numeric |
Not supported. Its value is NULL. |
max_extents |
numeric |
Not supported. Its value is NULL. |
pct_increase |
numeric |
Not supported. Its value is NULL. |
pct_threshold |
numeric |
Not supported. Its value is NULL. |
include_column |
numeric |
Not supported. Its value is NULL. |
freelists |
numeric |
Not supported. Its value is NULL. |
freelist_groups |
numeric |
Not supported. Its value is NULL. |
pct_free |
numeric |
Not supported. Its value is NULL. |
logging |
character varying(3) |
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. |
degree |
character varying(40) |
Not supported. Its value is NULL. |
instances |
character varying(40) |
Not supported. Its value is NULL. |
temporary |
character varying(1) |
Not supported. Its value is NULL. |
secondary |
character varying(1) |
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. |
duration |
character varying(15) |
Not supported. Its value is NULL. |
pct_direct_access |
numeric |
Not supported. Its value is NULL. |
ityp_owner |
character varying(128) |
Not supported. Its value is NULL. |
ityp_name |
character varying(128) |
Not supported. Its value is NULL. |
parameters |
character varying(1000) |
Not supported. Its value is NULL. |
global_stats |
character varying(3) |
Not supported. Its value is NULL. |
domidx_status |
character varying(12) |
Not supported. Its value is NULL. |
domidx_opstatus |
character varying(6) |
Not supported. Its value is NULL. |
funcidx_status |
character varying(8) |
Not supported. Its value is NULL. |
join_index |
character varying(3) |
Not supported. Its value is NULL. |
iot_redundant_pkey_elim |
character varying(3) |
Not supported. Its value is NULL. |
dropped |
character varying(3) |
Not supported. Its value is NULL. |
visibility |
character varying(9) |
Not supported. Its value is NULL. |
domidx_management |
character varying(14) |
Not supported. Its value is NULL. |
segment_created |
character varying(3) |
Not supported. Its value is NULL. |
orphaned_entries |
character varying(3) |
Not supported. Its value is NULL. |
indexing |
character varying(7) |
Not supported. Its value is NULL. |
auto |
character varying(3) |
Not supported. Its value is NULL. |
Feedback
Was this page helpful?
Provide feedbackThank you very much for your feedback. We will continue working to improve the documentation.