Distance Functions
AI Vector Search: New Vector Distance Metric
AI Vector Search was extended in Oracle AI Database 26ai, Release Update 23.6 to include a new vector distance metric called Jaccard distance.
This feature allows users the option to use another distance metric between vectors.
PL/SQL JACCARD Distance Support
The JACCARD distance metric is now supported in PL/SQL, which provides a similarity measure as a value from 0 to 1 between two BINARY vectors.
Jaccard distance is a common similarity measure for binary vectors. Support for JACCARD as a new metric in the PL/SQL VECTOR_DISTANCE operator means that PL/SQL code can make use of the JACCARD distance metric from within PL/SQL instead of calling out into SQL.