Was this helpful?
Limitations
The following restrictions apply to Vector indexes:
A table is only permitted to have one Vector index, but that index may be defined on multiple Vector-typed columns in that table.
Once a Vector index is created on a table, the table may not be modified unless the Vector index is dropped first.
The table must have a single-column integer-typed primary key. The Vector index uses this to identify each Vector in the column.
The distance metric intended to be used must be specified when the Vector index is created. Only EUCLIDEAN_SQUARED and DOT are supported.
A Vector column on which a Vector index is created must have a coordinate type of single-precision float. It may have any dimension.
Vector indexes are supported only on X100 tables, and not on Windows.
Last modified date: 09/11/2026