Question 160
A search procedure compares one query vector against stored vectors with a selected distance metric. The team is considering this step: Use VECTOR_DISTANCE in a scoped evaluated query with stable ordering. What evidence should they review before proceeding?
Explanation
Correct Answer
Confirm input dimensions, metric syntax, value validity and row filters. VECTOR_DISTANCE calculates a metric between compatible vectors in supported SQL engines.
Incorrect Answers
Vector existence alone is not metric compatibility. Check dimensions, valid values and cosine/euclidean/dot metric requirements.
A B-tree is not a vector index, and VECTOR_DISTANCE is exact scalar computation; it does not use ANN indexes.
Distance values between incompatible model spaces may be meaningless. Verify version, dimension and metric agreement.