SingleStore vector range search: EXPLAIN proves the index is used

TL;DR

In the EXPLAIN output, the ColumnStoreFilter row shows INTERNALVECTORRANGE_SEARCH when the plan uses a vector index for range search.

The error

EXPLAIN proves the index is used

Fix

1. In the EXPLAIN output, the ColumnStoreFilter row shows INTERNALVECTORRANGE_SEARCH when the plan uses a vector index for range search. Expected: you can confirm this matches your situation.

2. Re-run the original operation and confirm the error is gone. Expected: no error, normal output.

When to use

• You hit this exact error with SingleStore vector range search.
• The symptom matches: EXPLAIN proves the index is used.

When NOT to use

• A different error message from SingleStore vector range search; the cause here is specific to this error.
• Unrelated SingleStore vector range search issues (different feature, different failure).
• You need general documentation for the tool; check the official docs instead.

Compatibility

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

Variant phrasings

EXPLAIN proves the index is used

Why it happens

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

Edge cases

• If your error message differs even slightly, this is probably a different issue; search the exact text.
• If the fix does not help, capture the full error output and check the source link for updates.

Source

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

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/