Note
This variable is available starting with V4.5.0 for V4.5.x.
Description
ob_sparse_drop_ratio_search specifies the percentage of the smallest dimensions in the query vector to be set to 0 during sparse vector queries. This reduces the dimensionality and accelerates the query.
Applicability
This variable is applicable only to OceanBase Database in MySQL mode.
Privilege requirements
Query variables
- The
systenant and all user tenants can execute theSHOW VARIABLESstatement or query theinformation_schema.SESSION_VARIABLESview to view the values of session system variables.
- The
Modify variables
- The
systenant and all MySQL user tenants can directly modify the values of session system variables in their own tenant.
- The
Attributes
| Attribute | Description |
|---|---|
| Type | Uint |
| Default value | 0 |
| Value range | [0,100] |
| Scope | Session |
| Modifiable | Yes. You can execute the SET statement to modify the value. |
Examples
Set the percentage of the smallest dimensions in the query vector to be set to 0 during sparse vector queries to 30%.
obclient> SET ob_sparse_drop_ratio_search = 30;