database · inferred from evidence
JSON Search Index
A specialized index for searching JSON data within a database.
- Oracle vector store ignores JSON Search Index when vector index exists
When I use similarity_search with a metadata filter and both a vector index and a JSON Search Index exist, the JSON index is never used. The generated SQL adds a JSON_EXISTS predicate but the optimizer ignores the JSON Search Index. The not