10.155 V$VECTOR_INDEX

V$VECTOR_INDEX displays diagnostic information about vector indexes.

This view is populated only on Oracle Autonomous Database Serverless (ADB-S).

Column Datatype Description

OWNER

VARCHAR2(129)

Owner of the index

INDEX_NAME

VARCHAR2(129)

Name of the index

PARTITION_NAME

VARCHAR2(129)

Object partition name

The value of this column is null for non-partitioned objects.

INDEX_ORGANIZATION

VARCHAR2(129)

Type of index organization:

  • INMEMORY NEIGHBOR GRAPH

  • NEIGHBOR PARTITIONS

INDEX_OBJN

NUMBER

Index object number

ALLOCATED_BYTES

NUMBER

Total amount of memory allocated to the index (in bytes)

If the index is an IVF index, the value of this column is 0.

USED_BYTES

NUMBER

Total amount of memory currently used by the index (in bytes)

If the index is an IVF index, the value of this column is 0.

NUM_VECTORS

NUMBER

Number of vectors currently indexed in the main-memory storage of the index, as of the latest snapshot

NUM_REPOP

NUMBER

Number of times the index has been repopulated

INDEX_USED_COUNT

NUMBER

Number of times the index has been used by queries

DISTANCE_TYPE

VARCHAR2(129)

Distance metric for the index:

  • COSINE

  • DOT

  • EUCLIDEAN

  • EUCLIDEAN_SQUARED

  • HAMMING

  • MANHATTAN

INDEX_DIMENSIONS

NUMBER

Number of dimensions for the indexed vector

INDEX_DIM_TYPE

VARCHAR2(129)

Type of the dimensions for the indexed vector:

  • FLOAT16

  • FLOAT32

  • FLOAT64

  • INT8

DEFAULT_ACCURACY

NUMBER

Accuracy to achieve when performing approximate search on this index and a target query accuracy is not provided

CON_ID

NUMBER

The ID of the container to which the data pertains. Possible values include:

  • 0: This value is used for rows containing data that pertain to the entire CDB. This value is also used for rows in non-CDBs.

  • 1: This value is used for rows containing data that pertain to only the root

  • n: Where n is the applicable container ID for the rows containing data

Note:

This view is available starting with Oracle AI Database 26ai, Release Update 23.6.