V$VECTOR_INDEX

V$VECTOR_INDEX displays diagnostic information about vector indexes.

This view is populated only on Oracle Autonomous AI 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.