SingleStore: create a vector index with matching metric type and order
SingleStore: create a vector index with matching metric type and order: : create the index with ALTER TABLE ...
[docs.singlestore.com]: create the index with ALTER TABLE ... ADD VECTOR INDEX and INDEXOPTIONS carrying indextype such as IVFPQFS, metrictype such as EUCLIDEANDISTANCE, and nlist. Two conditions for index use: the metric in the query (dot product vs euclidean distance) matches the metric used to create the index, and the ORDER BY direction (DESC vs ASC) matches the metric. Check the plan with EXPLAIN: the ColumnStoreFilter line shows INTERNALVECTOR_SEARCH when the index is used, and its absence means a full scan.
Context: An ANN index that does not match the query's metric and sort direction is never used. The build parameters must agree with the queries.
Matched source
Source: Source: https://docs.singlestore.com/db/v8.9/reference/sql-reference/vector-functions/vector-indexing/ Original query: "SingleStore: create a vector index with matching metric type and order" Key terms: create, index, matching, metric, order, singlestore, type, vector
Maintainer review
No maintainer verification is recorded for this version.
This records the version a maintainer checked. It does not assert that the version is the latest upstream release.