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

Control the visibility of invisible index in session level #50653

Closed
1 task done
hawkingrei opened this issue Jan 23, 2024 · 0 comments · Fixed by #50733
Closed
1 task done

Control the visibility of invisible index in session level #50653

hawkingrei opened this issue Jan 23, 2024 · 0 comments · Fixed by #50733
Labels
type/enhancement The issue or PR belongs to an enhancement.

Comments

@hawkingrei
Copy link
Member

hawkingrei commented Jan 23, 2024 •
edited
Loading

Enhancement

We already have "invisible index" implemented. However, variable use_invisible_indexes was not included. This could be caused by incomplete support of optimizer_switches.

As we are about to support index advisor in H1. This ability becomes important to verify the proposed indexes. Before implementing optimizer_switches, we could introduce a new variable in TiDB for this purpose.
@hawkingrei hawkingrei added the type/enhancement The issue or PR belongs to an enhancement. label Jan 23, 2024
@hawkingrei hawkingrei changed the title Uploaded image for project: 'Feature Development' Feature DevelopmentFD-1401 Control the visibility of invisible index in session level Control the visibility of invisible index in session level Jan 23, 2024
@hawkingrei hawkingrei mentioned this issue Jan 23, 2024
Merged
13 tasks
ti-chi-bot bot pushed a commit that referenced this issue Jan 25, 2024
@hawkingrei
*: support tidb_opt_use_invisible_indexes (#50654)
e42d0bf 
ref #50653
@hawkingrei hawkingrei mentioned this issue Jan 25, 2024
Merged
13 tasks
ti-chi-bot bot pushed a commit that referenced this issue Jan 26, 2024
@hawkingrei
*: tidb_opt_use_invisible_indexes support set_var (#50733)
34449ef 
close #50653
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.

*: tidb_opt_use_invisible_indexes support set_var hawkingrei/tidb
1 participant
@hawkingrei