Note
In OceanBase Database V4.x, the corresponding logic is changed, and the corresponding feature is no longer available. This variable has been deprecated since OceanBase Database V4.0.0.
Description
ob_enable_blk_nestedloop_join specifies whether to enable Block Nested Loop (BNL) join.
Attributes
| Attribute | Description |
|---|---|
| Type | Boolean |
| Default value | 0 |
| Value range |
|
| Effective scope |
|
| Modifiable | Yes. You can use the SET statement to modify the variable. |
| Plan generation affected | Yes |