SingleStore vector range search: EXPLAIN proves the index is used

[docs.singlestore.com]: in the EXPLAIN output, the ColumnStoreFilter row shows INTERNALVECTORRANGE_SEARCH when the plan uses a vector index for range search. Use index hints to pin behavior: USE INDEX with the index name forces a specific vector index and errors if that index is not available, while empty parentheses USE INDEX () disables vector index use entirely. List indexes with SHOW INDEXES. Reference: the Vector Range Search page in the SingleStore docs.

Context: Vector range queries can silently fall back to full scans. The EXPLAIN plan tells you whether the index kicked in.

Source: Vector range queries can silently fall back to full scans. The EXPLAIN plan tells you whether the index kicked in.

Verified resolution: [docs.singlestore.com]: in the EXPLAIN output, the ColumnStoreFilter row shows INTERNALVECTORRANGE_SEARCH when the plan uses a vector index for range search. Use index hints to pin behavior: USE INDEX with the index name forces a specific vector index and errors if that index is not available, while empty parentheses USE INDEX () disables vector index use entirely. List indexes with SHOW INDEXES. Reference: the Vector Range Search page in the SingleStore docs.

Source URL: https://docs.singlestore.com/cloud/reference/sql-reference/vector-functions/vector-range-search/