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 avoid table scans for pseudo stats if index scan exists #55632

Closed
terry1purcell opened this issue Aug 23, 2024 · 0 comments · Fixed by #55633 or #56928
Closed

Planner avoid table scans for pseudo stats if index scan exists #55632

terry1purcell opened this issue Aug 23, 2024 · 0 comments · Fixed by #55633 or #56928
Labels
affects-8.5 This bug affects the 8.5.x(LTS) versions. report/customer Customers have encountered this bug. type/enhancement The issue or PR belongs to an enhancement.

Comments

@terry1purcell
Copy link
Contributor

Enhancement

Pseudo stats are unreliable. Preference a matching index scan over table scan for pseudo stats.
@terry1purcell terry1purcell added the type/enhancement The issue or PR belongs to an enhancement. label Aug 23, 2024
@terry1purcell terry1purcell mentioned this issue Aug 23, 2024
Merged
13 tasks
ti-chi-bot bot pushed a commit that referenced this issue Sep 10, 2024
@terry1purcell
planner: preference range scan for pseudo (#55633)
d2656d2 
close #55632
Benjamin2037 pushed a commit to Benjamin2037/tidb that referenced this issue Sep 11, 2024
@terry1purcell @Benjamin2037
planner: preference range scan for pseudo (pingcap#55633)
c4b802e 
close pingcap#55632
@terry1purcell terry1purcell mentioned this issue Oct 29, 2024
Merged
13 tasks
ti-chi-bot bot pushed a commit that referenced this issue Dec 9, 2024
@terry1purcell
planner: Use/force to apply prefer range scan (#56928)
cdfdb8a 
close #55632
@ti-chi-bot ti-chi-bot bot added the affects-8.1 This bug affects the 8.1.x(LTS) versions. label Dec 17, 2024
@seiya-annie seiya-annie added the report/customer Customers have encountered this bug. label Dec 18, 2024
ti-chi-bot pushed a commit to ti-chi-bot/tidb that referenced this issue Dec 20, 2024
@terry1purcell @ti-chi-bot
planner: Use/force to apply prefer range scan (pingcap#56928)
108f04d 
close pingcap#55632
@ti-chi-bot ti-chi-bot mentioned this issue Dec 20, 2024
Merged
13 tasks
@ti-chi-bot ti-chi-bot bot added affects-8.5 This bug affects the 8.5.x(LTS) versions. and removed affects-8.1 This bug affects the 8.1.x(LTS) versions. labels Dec 20, 2024
ti-chi-bot bot pushed a commit that referenced this issue Dec 23, 2024
@ti-chi-bot
planner: Use/force to apply prefer range scan (#56928) (#58444)
13852cc 
close #55632
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
affects-8.5 This bug affects the 8.5.x(LTS) versions. report/customer Customers have encountered this bug. type/enhancement The issue or PR belongs to an enhancement.
Projects
None yet
Milestone
No milestone
2 participants
@seiya-annie @terry1purcell