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

DB_INDEXES

DB_INDEXES displays information about indexes accessible to the current user. This view exists in the PG_CATALOG and SYS schemas.

Table 1 DB_INDEXES columns

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 unique.

  • UNIQUE: unique index.
  • NONUNIQUE: non-unique index.

partitioned

character(3)

Specifies whether the index has the property of partitioned tables.

  • Yes: The index has the property of a partitioned table.
  • No: The index does not have the property of a partitioned table.

generated

character varying(1)

Specifies whether the name of the index is generated by the system.

  • y: The index name is generated by the system.
  • n: The index name is not generated by the system.

index_type

character varying(27)

Index type

  • NORMAL: Index attributes are simple references, and the expression tree is empty.
  • FUNCTION-BASED NORMAL: Expression trees are used for index attributes that are not simple column references.

table_owner

character varying(128)

Owner of the index object

table_type

character(11)

Type of an index object

  • TABLE: The index object is of the table type.

tablespace_name

character varying(30)

Name of the tablespace that contains the index

status

character varying(8)

Status of a non-partitioned index.

  • VALID: Non-partitioned indexes can be used for query.
  • UNUSABLE: The non-partitioned index is unavailable.
  • N/A: The index has the property of a partitioned table.

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)

Specifies whether the index is visible to the optimizer.

  • VISIBLE: The index is visible to the optimizer.
  • INVISIBLE: The index is visible to the optimizer.

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.