V$VECTOR_INDEX

This fixed view provides diagnostic information about vector indexes and is available with Autonomous AI Database Serverless (ADB-S).

Column Name Data Type Description
OWNER VARCHAR(129) User name of the vector index owner
INDEX_NAME VARCHAR(129) Name of the vector index
PARTITION_NAME VARCHAR(129) Object partition name (set to NULL for non-partitioned objects)
INDEX_ORGANIZATION VARCHAR(129)

The vector index organization. The value can be one of the following:

  • NEIGHBOR PARTITIONS
  • INMEMORY NEIGHBOR GRAPH
  • DISTRIBUTED INMEMORY NEIGHBOR GRAPH
INDEX_OBJN NUMBER Index object number
ALLOCATED_BYTES NUMBER

Total amount of memory allocated to this vector index, in bytes.

When the vector index is an IVF index, the value is 0.

USED_BYTES NUMBER

Total amount of memory currently used by the vector index, in bytes.

When the vector index is an IVF index, the value is 0.

NUM_VECTORS NUMBER The number of vectors currently indexed in the main-memory storage of the index as of the latest snapshot
NUM_REPOP NUMBER Number of times this index has been repopulated
INDEX_USED_COUNT NUMBER Number of times this vector index has been used by queries
DISTANCE_TYPE VARCHAR2(129)

Possible distance values:

  • EUCLIDEAN
  • EUCLIDEAN_SQUARED
  • COSINE
  • DOT
  • MANHATTAN
  • HAMMING
INDEX_DIMENSIONS NUMBER Number of dimensions of the indexed vector
INDEX_DIM_TYPE VARCHAR2(129)

Type of the dimensions of the index vector.

Possible values:

  • FLOAT16
  • FLOAT32
  • FLOAT64
  • INT8
DEFAULT_ACCURACY NUMBER The accuracy to achieve when performing approximate search on this vector index if a target query accuracy is not provided
CON_ID NUMBER

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

  • 0: This value is used for rows containing data that pertain to the entire multitenant container database (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.