1Z0-184-25 Question 7
Single answerYou have deployed an Oracle Database 23c instance on Oracle Cloud Infrastructure (OCI) to store high-dimensional vector embeddings for a personalized recommendation engine. Your goal is to perform high-performance similarity searches for user recommendations in real time. Which approach provides the most efficient way to achieve minimal latency when querying for approximate nearest neighbors (ANN) on the stored vectors?
- A
Create an ANN index on the vector column to optimize similarity searches.
- B
Use a traditional B-tree index on the vector column for efficient queries.
- C
Convert the vector data into JSON format and rely on Oracle JSON search features.
- D
Export the vectors into a separate third-party analytics engine for dedicated vector search.
Show answer and explanation
Correct answer: A
Explanation
For high-dimensional vector searches, Oracle Database 23c provides native vector data types and specialized approximate nearest neighbor (ANN) indexing, ensuring optimal performance for similarity queries. Refer to the Oracle Database 23c documentation on vector search for best practices on creating and maintaining ANN indexes.
- A. Correct.
Correct. Oracle Database 23c supports creating an approximate nearest neighbor (ANN) index on vector columns. This specialized index accelerates similarity queries by quickly narrowing down to the most relevant vectors based on distance metrics, minimizing query latency.
- B. Incorrect.
Incorrect. B-tree indexes are not designed for high-dimensional similarity searches. They work efficiently for exact matches or range queries on scalar values but not for vector-based nearest neighbor queries.
- C. Incorrect.
Incorrect. Storing vectors as JSON and using Oracle JSON search cannot leverage the specialized indexing needed for vector similarity. This approach would be significantly slower and more complex for high-dimensional data.
- D. Incorrect.
Incorrect. While external analytics engines can handle vector data, this approach introduces data movement, network latency, and ongoing synchronization challenges. Oracle Database 23c� native ANN index is more direct and efficient within OCI.