CREATE VECTOR INDEX
Valid in: SQL, ESQL, OpenAPI, ODBC, JDBC, .NET
The CREATE VECTOR INDEX statement creates a Vector index on one or more columns of an existing table to support similarity search.
This statement has the following format:
CREATE <metric> VECTOR INDEX (<index name> ON <table name> (<col1>, <col2>, ...));
metric
Specifies the distance metric to be used by the Vector index. The supported distance metrics for Vector indexes are EUCLIDEAN_SQUARED and DOT.
index name
Specifies the name of the index.
table name
Specifies the name of the table on which to create the Vector index. The named columns <col1>, <col2>, … must have type Vector with coordinate type FLOAT4, and the table must have a single-column integer primary key.
Last modified date: 09/11/2026