runtime_filter_type specifies the runtime filter type at the tenant level.
Note
This variable is introduced since 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 |
| Applicable scope |
|
| Read-only | No |
| Plan generation affected | Yes |
| Effective only after restart | No |
Example
set runtime_filter_type = 'range,in,bloom_filter';
set global runtime_filter_type = 'range';
set runtime_filter_type = '';