V$VECTOR_PARTITIONS_INDEX

V$VECTOR_PARTITIONS_INDEX displays diagnostic information about Inverted File Flat 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_OBJN NUMBER Index object number
CENTROIDS_ANCHOR_ADDRESS RAW(8)

Address of the anchor structure hosting the centroids for the in-memory neighbor partitions index in the vector pool.

If in-memory centroids are unavailable for the index, the value of this column is 0.

INDEX_PARTITIONS_TYPE VARCHAR2(129)

Index partition type

The value of this column is always IVF.

NUM_NEIGHBOR_PARTITIONS NUMBER Number of neighbor partitions created for the index
NUM_VECTORS NUMBER Number of indexed vectors in the index
MIN_PARTITION_VECTORS_COUNT NUMBER Number of vectors in the smallest neighbor partition
MAX_PARTITION_VECTORS_COUNT NUMBER Number of vectors in the largest neighbor partition
INDEX_USED_COUNT NUMBER Number of times the vector partition index has been used by queries
AVG_PARTITIONS_SCANNED NUMBER

Average number of neighbor partitions scanned in order to answer queries.

This value is an average over the NEIGHBOR PROBES query parameter supported for an Inverted File neighbor partitions index

QUANTIZATION_TYPEFoot 1 VARCHAR2(129) Quantization type, such as SCALAR or PRODUCT
QUANTIZATION_MDATAFoot 1 JSON For scalar quantized IVF indexes, the quantization metadata, in JSON format. Otherwise, null.
QUANT_CACHE_LOCATIONFoot 1 VARCHAR2(129)

Quantization cache location:

  • VECTOR POOL

  • LARGE POOL

  • NO
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

Footnote 1 This column is available starting with Oracle AI Database 26ai, Release Update 23.26.4.

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