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