OceanBase Database can store, index, and search vector data. The following table describes the core features.
| Core feature | Description |
|---|---|
| Vector data types |
|
| Vector index |
|
| Vector search SQL operators | Supports basic operators for vector addition, subtraction, multiplication, comparison, and aggregation. |
Limitations and considerations
- By default, OceanBase Database uses the nullsFirst comparison mode, in which NULL values are placed first during sorting. We recommend that you add a
NOT NULLcondition in queries. - OceanBase Database Community Edition and Desktop Edition allow you to use vector search in the SYS and user tenants. OceanBase Database Enterprise Edition allows you to use vector search only in the user tenant.