Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

planner: support more hints about join selection #45520

Closed
qw4990 opened this issue Jul 24, 2023 · 0 comments
Closed

planner: support more hints about join selection #45520

qw4990 opened this issue Jul 24, 2023 · 0 comments
Assignees
@qw4990
Labels
affects-6.5 This bug affects the 6.5.x(LTS) versions. affects-7.1 This bug affects the 7.1.x(LTS) versions. epic/hint sig/planner SIG: Planner type/enhancement The issue or PR belongs to an enhancement.

Comments

@qw4990
Copy link
Contributor

qw4990 commented Jul 24, 2023 •
edited
Loading

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 -
@qw4990 qw4990 added type/enhancement The issue or PR belongs to an enhancement. sig/planner SIG: Planner epic/hint labels Jul 24, 2023
@qw4990 qw4990 mentioned this issue Jul 24, 2023
Merged
12 tasks
ti-chi-bot bot pushed a commit that referenced this issue Jul 24, 2023
@qw4990
parser: support more join hints on parser (#45525)
e68c8ff 
ref #45520
@qw4990 qw4990 mentioned this issue Jul 24, 2023
Merged
12 tasks
ti-chi-bot bot pushed a commit that referenced this issue Jul 24, 2023
@qw4990
planner: support no_hash_join hint on optimizer (#45538)
7c2dbbe 
ref #45520
@qw4990 qw4990 mentioned this issue Jul 25, 2023
Merged
12 tasks
ti-chi-bot bot pushed a commit that referenced this issue Jul 25, 2023
@qw4990
planner: support no_merge_join hint on optimizer (#45562)
ef27b0e 
ref #45520
This was referenced Jul 26, 2023
Merged
Merged
This was referenced Jul 26, 2023
Closed
Merged
@qw4990 qw4990 added affects-6.5 This bug affects the 6.5.x(LTS) versions. affects-7.1 This bug affects the 7.1.x(LTS) versions. labels Jul 26, 2023
ti-chi-bot bot pushed a commit that referenced this issue Jul 26, 2023
@ti-chi-bot
parser: support more join hints on parser (#45525) (#45574)
8e174f0 
ref #45520
ti-chi-bot bot pushed a commit that referenced this issue Jul 26, 2023
@qw4990
planner: refine tryToGetIndexJoin (#45587)
64be9ec 
ref #45520
This was referenced Jul 26, 2023
Closed
Closed
@qw4990 qw4990 self-assigned this Jul 27, 2023
@qw4990 qw4990 mentioned this issue Jul 27, 2023
Merged
12 tasks
ti-chi-bot bot pushed a commit that referenced this issue Jul 28, 2023
@qw4990
planner: refactor tryToGetIndexJoin (#45617)
79f0001 
ref #45520
This was referenced Jul 28, 2023
Closed
Closed
ti-chi-bot bot pushed a commit that referenced this issue Jul 28, 2023
@ti-chi-bot
parser: support more join hints on parser (#45525) (#45573)
65f6531 
ref #45520
@qw4990 qw4990 mentioned this issue Jul 28, 2023
Merged
12 tasks
This was referenced Jul 28, 2023
Merged
Closed
Closed
Closed
@ti-chi-bot ti-chi-bot mentioned this issue Jul 28, 2023
Merged
12 tasks
ti-chi-bot bot pushed a commit that referenced this issue Jul 28, 2023
@ti-chi-bot
planner: support no_hash_join hint on optimizer (#45538) (#45635)
138562f 
ref #45520
ti-chi-bot bot pushed a commit that referenced this issue Jul 28, 2023
@ti-chi-bot
planner: support no_hash_join hint on optimizer (#45538) (#45654)
e44839c 
ref #45520
ti-chi-bot bot pushed a commit that referenced this issue Jul 28, 2023
@qw4990
planner: support no_index_join, no_index_hash_join, `no_index_mer…
c266a97 
…ge_join` hints (#45633)

ref #45520
This was referenced Jul 28, 2023
Closed
Closed
Merged
Merged
ti-chi-bot bot pushed a commit that referenced this issue Aug 1, 2023
@ti-chi-bot
planner: support no_merge_join hint on optimizer (#45562) (#45704)
05d7505 
ref #45520
ti-chi-bot bot pushed a commit that referenced this issue Aug 1, 2023
@ti-chi-bot
planner: support no_merge_join hint on optimizer (#45562) (#45705)
4c91878 
ref #45520
This was referenced Aug 1, 2023
Merged
Merged
ti-chi-bot bot pushed a commit that referenced this issue Aug 1, 2023
@ti-chi-bot
planner: refine tryToGetIndexJoin (#45587) (#45713)
299dd2d 
ref #45520
ti-chi-bot bot pushed a commit that referenced this issue Aug 1, 2023
@ti-chi-bot
planner: refine tryToGetIndexJoin (#45587) (#45712)
0adf0ac 
ref #45520
This was referenced Aug 7, 2023
Merged
Merged
ti-chi-bot bot pushed a commit that referenced this issue Aug 7, 2023
@ti-chi-bot
planner: refactor tryToGetIndexJoin (#45617) (#45841)
032726c 
ref #45520
ti-chi-bot bot pushed a commit that referenced this issue Aug 7, 2023
@ti-chi-bot
planner: refactor tryToGetIndexJoin (#45617) (#45840)
325a8b8 
ref #45520
This was referenced Aug 8, 2023
Closed
Merged
@qw4990 qw4990 mentioned this issue Aug 8, 2023
Merged
12 tasks
ti-chi-bot bot pushed a commit that referenced this issue Aug 8, 2023
@ti-chi-bot
planner: support no_index_join, no_index_hash_join, `no_index_mer…
e21efe5 
…ge_join` hints (#45633) (#45882)

ref #45520
ti-chi-bot bot pushed a commit that referenced this issue Aug 9, 2023
@qw4990
planner: support no_index_join, no_index_hash_join, `no_index_mer…
f028669 
…ge_join` hints (#45633) (#45912)

ref #45520
@qw4990 qw4990 closed this as completed Sep 13, 2023
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees

@qw4990 qw4990

Labels
affects-6.5 This bug affects the 6.5.x(LTS) versions. affects-7.1 This bug affects the 7.1.x(LTS) versions. epic/hint sig/planner SIG: Planner type/enhancement The issue or PR belongs to an enhancement.
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
1 participant
@qw4990