8.1.11 The rpd_vector_indexes Table

The rpd_vector_indexes table provides information about vector indexes created for different vector store or embedding tables.

The rpd_vector_indexes table has these columns:

• TABLE_ID: the table ID.

• COLUMN_ID: the column ID.

• SPACE: Vector distance metric, which can be one of: DOT, EUCLIDEAN, and COSINE. Queries using the same distance metric are accelerated by the index.

• ALGORITHM: vector indexing algorithm used, which is always HNSW as of MySQL 9.5.0.

• TUNING_PARAMS: the parameters used for tuning the vector index.

• ORDER: the order used for index creation: ACS or DESC.

• SIZE_MB: the size of the index per-rapid-node, in MB.

• USAGE_COUNT: the number of times the index has been used.

• BUILD_START_TIME: index build start time.

• BUILD_END_TIME: index build end time.

• IS_USABLE: whether the index is usable.

The rpd_vector_indexes table is read-only.