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 performance for the BuildHistAndTopN #49180

Open
hawkingrei opened this issue Dec 5, 2023 · 0 comments · May be fixed by #48902
Open

improve performance for the BuildHistAndTopN #49180

hawkingrei opened this issue Dec 5, 2023 · 0 comments · May be fixed by #48902
Labels
type/enhancement The issue or PR belongs to an enhancement.

Comments

@hawkingrei
Copy link
Member

hawkingrei commented Dec 5, 2023 •
edited
Loading

Enhancement

Now, Analyze will take most of the time on the BuildHistAndTopN. BuildHistAndTopN have many unnecessary sort and compare with low NDV. so we can merge the same data then sort and compare. it will have better performance.
@hawkingrei hawkingrei added the type/enhancement The issue or PR belongs to an enhancement. label Dec 5, 2023
This was referenced Dec 5, 2023
Open
Open
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
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.

*: improve performance for BuildHistAndTopN hawkingrei/tidb
1 participant
@hawkingrei