product · inferred from evidence
VECTOR_INDEX_TRANSFORM
A specific optimizer hint used to ensure vector indexes are considered in query plans.
- Oracle vector store ignores JSON Search Index when vector index exists
The problem was the generated SQL was missing the optimizer hint that makes the database consider both indexes, so the JSON Search Index sat unused whenever a vector index existed. The fix adds the VECTOR_INDEX_TRANSFORM hint to the query,