optimizer_dynamic_sampling specifies the level of dynamic sampling.
Note
This variable was introduced in OceanBase Database V4.2.0.
Attribute |
Description |
|---|---|
| Type | Integer |
| Default value | 1 |
| Value range | [0, 1] |
| Effective scope |
|
| Read-only | No |
| Involved in serialization | Yes |
| Effective only after restart | No |
Examples
set optimizer_dynamic_sampling = 0;
set global optimizer_dynamic_sampling = 1;