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 out-of-range handling logic #26086

Closed
Tracked by #26085
time-and-fate opened this issue Jul 9, 2021 · 1 comment · Fixed by #26502
Closed
Tracked by #26085

Improve out-of-range handling logic #26086

time-and-fate opened this issue Jul 9, 2021 · 1 comment · Fixed by #26502
Labels
sig/planner SIG: Planner type/enhancement The issue or PR belongs to an enhancement.

Comments

@time-and-fate
Copy link
Member

time-and-fate commented Jul 9, 2021 •
edited
Loading

Enhancement

Currently, when doing the row count estimation for a range condition, we're using a fixed 1/100 selectivity for the out-of-range part if it is out of the range of our histogram. But this rule is too simple sometimes, we'll try to switch to a smarter strategy.
@time-and-fate time-and-fate added the type/enhancement The issue or PR belongs to an enhancement. label Jul 9, 2021
@time-and-fate
Copy link
Member Author

/sig planner

@ti-chi-bot ti-chi-bot added the sig/planner SIG: Planner label Jul 9, 2021
@time-and-fate time-and-fate mentioned this issue Jul 9, 2021
Closed
6 tasks
@time-and-fate time-and-fate mentioned this issue Jul 23, 2021
Merged
4 tasks
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
sig/planner SIG: Planner type/enhancement The issue or PR belongs to an enhancement.
Projects
None yet
Milestone
No milestone
Development

Successfully merging a pull request may close this issue.

statistics: improve out-of-range estimation strategy time-and-fate/tidb
2 participants
@time-and-fate @ti-chi-bot