Skip to content

Implement support for SQL Server VECTOR_SEARCH() #36384

@roji

Description

@roji

#36383 is adding support for the new SQL Server vector data type, as well as the translation of VECTOR_DISTANCE(), which performs precise, slow (non-index-driven) similarity search. In contrast, [VECTOR_SEARCH())(https://learn.microsoft.com/en-us/sql/t-sql/functions/vector-search-transact-sql?view=sql-server-ver17) allows approximate, index-driven search.

VECTOR_SEARCH() seems to be in a more experimental stage at this point, and its design as a special TVF (as opposed to VECTOR_DISTANCE() which is just a regular scalar function) both makes translation more difficult to implement, and may make it difficult to allow users to use pre-filtering. So I've split this off from the main issue for now.

Metadata

Metadata

Assignees

Projects

No projects

Relationships

None yet

Development

No branches or pull requests

Issue actions