md#tidb_opt_enable_hash_join-new-in-v740) is set to `OFF`, and all other join types are also excluded. - The system variable [`tidb_opt_enable_hash_join`](/system-variables.md#tidb_opt_enable_hash_join-new-in-v656-v712-and-v740) is set to `OFF`, and all other join types are...
md#tidb_opt_enable_hash_join-new-in-v740) is set to `OFF`, and all other join types are also excluded. - The system variable [`tidb_opt_enable_hash_join`](/system-variables.md#tidb_opt_enable_hash_join-new-in-v656-v712-and-v740) is set to `OFF`, and all other join types ...
你需要体系化了解一下
Optimizer _ features _ enable string 12.1.0.1You generated the execution plan for the following query in the plan table and noticed that the nested loop join was done. After actual execution of the query, you notice that the hash join was done in the execution plan:...