Note
This variable is introduced in V4.3.5 BP2.
Description
ob_sparse_drop_ratio_search is used during sparse vector queries to set the smallest portion of dimension values in the query vector to 0. This reduces the dimensionality and accelerates the query process.
Applicability
This variable applies only to the MySQL-compatible mode of OceanBase Database.
Privilege requirements
Query variables
- Both the
systenant and all user tenants can use theSHOW VARIABLESstatement or theinformation_schema.SESSION_VARIABLESview to check the values of session system variables.
- Both the
Modify variables
- Both the
systenant and all MySQL-compatible tenants can directly modify the values of session system variables for their respective tenants.
- Both the
Attributes
| Attribute | Description |
|---|---|
| Parameter type | Uint |
| Default value | 0 |
| Value range | [0,100] |
| Effect scope | SESSION |
| Modifiable? | Yes. You can use the SET or ALTER SESSION SET statement to modify it. |
Examples
When configuring sparse vector queries, set the smallest 30% of dimension values in the query vector to 0.
obclient> SET ob_sparse_drop_ratio_search = 30;