planner: support more hints about join selection #45520
Closed
Description
Enhancement
Support more join hints:
| hint name | description | parser | optimizer |
|---|---|---|---|
| NO_HASH_JOIN | don't consider HashJoin for specified tables | #45525 | #45538 |
| NO_MERGE_JOIN | don't consider MergeJoin for specified tables | #45525 | #45562 |
| NO_INDEX_JOIN | don't consider IndexJoin for specified tables | #45525 | #45587 #45617 #45633 |
| NO_INDEX_HASH_JOIN | don't consider IndexHashJoin for specified tables | #45525 | #45633 |
| NO_INDEX_MERGE_JOIN | don't consider IndexMergeJoin for specified tables | #45525 | #45633 |
| INDEX_JOIN | use IndexJoin (not IndexHashJoin or IndexMergeJoin) for specified tables | #45525 | - |
| INDEX_HASH_JOIN | use IndexHashJoin for specified tables | #45525 | - |
| INDEX_MERGE_JOIN | use IndexMergeJoin for specified tables | #45525 | - |