Skip to content

[MEVD] [SQL Server] Support approximate/index-based vector search via VECTOR_SEARCH() #13270

@roji

Description

@roji

We currently perform all vector search via VECTOR_DISTANCE(), which performs precise vector search via brute-force (no index). SQL Server 2025 is also introducing VECTOR_SEARCH(), which leverages indexing to perform faster, approximate vector search.

VECTOR_SEARCH() is currently still in preview and is expected to change; but implement support for it - and for creating the DiskANN vector index which drives it.

Note: in its current state VECTOR_SEARCH() accepts a TOP_N parameter, meaning that pre-filtering cannot be done.

Don't forget to do this for hybrid search as well.

/cc @yorek

Metadata

Metadata

Assignees

Labels

msft.ext.vectordataRelated to Microsoft.Extensions.VectorData

Projects

Status

Sprint: Done

Relationships

None yet

Development

No branches or pull requests

Issue actions