optimizer_dynamic_sampling specifies the level of dynamic sampling.
Note
This variable is introduced since OceanBase Database V4.2.0.
| Attribute | Description |
|---|---|
| Type | INT |
| Default value | 1 |
| Value range | [0, 1] |
| Applicable 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;