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

PR #97823 - opt: split disjunction in join conditions in more cases #16384

Open
cockroach-teamcity opened this issue Mar 1, 2023 · 1 comment
Open

PR #97823 - opt: split disjunction in join conditions in more cases #16384

cockroach-teamcity opened this issue Mar 1, 2023 · 1 comment
Assignees
@taroface
Labels
C-product-change release-22.2

Comments

@cockroach-teamcity
Copy link
Member

cockroach-teamcity commented Mar 1, 2023 •
edited by exalate-issue-sync bot
Loading

Exalate commented:

Related PR: cockroachdb/cockroach#97823
Commit: cockroachdb/cockroach@88e9d61
Fixes: cockroachdb/cockroach#97695

Release note (performance improvement): if the session setting
optimizer_use_improved_split_disjunction_for_joins is true, the optimizer
now creates a better query plan in some cases where an inner, semi, or
anti join contains a join predicate with a disjuction (OR condition).

Jira Issue: DOC-7088
@exalate-issue-sync
Copy link

Mike Lewis (mikeCRL) commented:
Routed to SQL Queries based on cockroach package https://cockroachlabs.atlassian.net/wiki/spaces/ED/pages/2934931562/Routing+issues+to+Product+Areas

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees

@taroface taroface

Labels
C-product-change release-22.2
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
2 participants
@taroface @cockroach-teamcity