runtime_filter_type specifies the runtime filter type at the tenant level.
Note
This variable is available in OceanBase Database V4.2.0 and later.
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. |
| Applicable scope |
|
| Read-only? | No |
| Plan generation affected? | Yes |
| Effective only after restart? | No |
Sample code
set runtime_filter_type = 'range,in,bloom_filter';
set global runtime_filter_type = 'range';
set runtime_filter_type = '';