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

Improve join cardinality estimate #10862

Closed
xudong963 opened this issue Mar 30, 2023 · 1 comment · Fixed by #11105
Closed

Improve join cardinality estimate #10862

xudong963 opened this issue Mar 30, 2023 · 1 comment · Fixed by #11105
Assignees
@xudong963
Labels
A-planner Area: planner/optimizer

Comments

@xudong963
Copy link
Member

xudong963 commented Mar 30, 2023 •
edited
Loading

Summary

For tables

CREATE TABLE t19 AS SELECT * FROM numbers(100000000);
CREATE TABLE t20 AS SELECT * FROM numbers(250000000);

image
@xudong963 xudong963 self-assigned this Mar 30, 2023
@xudong963 xudong963 added the A-planner Area: planner/optimizer label Mar 30, 2023
@xudong963
Copy link
Member Author

After disabling histogram, things goes well:

image

So I'll focus on improving histogram accuracy

@xudong963 xudong963 moved this to 📖In Progress in Databend Query Planner Apr 13, 2023
@xudong963 xudong963 mentioned this issue Apr 18, 2023
Merged
@github-project-automation github-project-automation bot moved this from 📖In Progress to 📕Done in Databend Query Planner Apr 18, 2023
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees

@xudong963 xudong963

Labels
A-planner Area: planner/optimizer
Projects
Databend Query Planner
Status: 📕Done
Milestone
No milestone
Development

Successfully merging a pull request may close this issue.

fix: join cardinality estimate xudong963/databend
1 participant
@xudong963