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