ob_enable_blk_nestedloop_join

2025-11-19 10:08:13  Updated

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
  • 0: disable
  • 1: enable
  • Effective scope
  • Global
  • Session
  • Modifiable Yes. You can use the SET statement to modify the variable.
    Plan generation affected Yes

    Contact Us