How to View and Modify the Default Value of tidb_enable_outer_join_reorder

Note:
This topic has been translated from a Chinese forum by GPT and might contain errors.

Original topic: 如何查看、修改 tidb_enable_outer_join_reorder的默认值

| username: xiaoxiaozuofang

【TiDB Usage Environment】Production Environment / Testing
【TiDB Version】
【Reproduction Path】What operations were performed when the issue occurred
【Encountered Issue: How to view and modify the default value of tidb_enable_outer_join_reorder
【Resource Configuration】Go to TiDB Dashboard - Cluster Info - Hosts and take a screenshot of this page
【Attachments: Screenshots/Logs/Monitoring】

| username: 裤衩儿飞上天 | Original post link

Check: show variables like ‘%tidb_enable_outer_join_reorder%’;
Modify: set global tidb_enable_outer_join_reorder=off;
After modification, it does not take effect for the current session. You need to open a new session or log out and log in again to query.

| username: 考试没答案 | Original post link

You can also check the official documentation.

| username: dba远航 | Original post link

show variables like ‘%tidb_enable_outer_join_reorder%’;
set global (session) tidb_enable_outer_join_reorder=off;

| username: Kongdom | Original post link

The document clearly explains how to operate from the beginning.

| username: system | Original post link

This topic was automatically closed 60 days after the last reply. New replies are no longer allowed.