optimize the behavior of the `tidb_enable_hash_join=off`
Open
sig/planner
type/enhancement
- Dominant language
- Go
- Stars
- 40.5k
- Forks
- 6.2k
- PR merge metrics
- PR metrics pending
Description
## Enhancement
It will generate a useless MergeJoin operator, which can produce noise for choosing an index join.
This is a related issue to https://github.com/pingcap/tidb/issues/61501
Contributor guide
Assessment
This issue has not been assessed yet.