runtime_filter_type specifies the runtime filter type at the tenant level.
Note
This variable was introduced in OceanBase Database V4.2.0.
Attribute |
Description |
|---|---|
| Type | Varchar |
| Default value | BLOOM_FILTER,RANGE,IN |
| Value range |
NoteIf you want to use runtime filters, you must specify at least one of the BLOOM_FILTER, RANGE, and IN values. |
| Effective scope |
|
| Read-only | No |
| Plan generation affected | Yes |
| Effective only after restart | No |
Examples
set runtime_filter_type = 'range,in,bloom_filter';
set global runtime_filter_type = 'range';
set runtime_filter_type = '';