This topic describes some common issues about vector search and their causes and solutions.
Does OceanBase Database support vector search in MySQL mode and Oracle mode?
OceanBase Database in MySQL mode supports vector search. OceanBase Database in Oracle mode does not support vector search for the time being.
Must all rows in a vector column have the same dimension?
Yes. You must specify the dimension when you define a vector column, and check the dimension when you write vector data.
How many rows of vector data can be written?
There is no limit. It depends on the memory resources of the tenant.
How to create an index for a vector with more than 2,000 dimensions?
You must perform dimension compression on the data and then create an index for the compressed vector, which has fewer than 2,000 dimensions.