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.

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

planner: support hypo-indexes #43817

Closed
qw4990 opened this issue May 15, 2023 · 0 comments · Fixed by #43607 or #44944
Closed

planner: support hypo-indexes #43817

qw4990 opened this issue May 15, 2023 · 0 comments · Fixed by #43607 or #44944
Assignees
Labels
sig/planner SIG: Planner type/feature-request This is a feature requests on the product

Comments

@qw4990
Copy link
Contributor

qw4990 commented May 15, 2023

Feature Request

Is your feature request related to a problem? Please describe:

Support hypo-indexes, which can help the index advisor to know whether some indexes are worthwhile for some particular queries.

Describe the feature you'd like:

  1. Support to use create index {name} type hypo on {table} (c1, c2) to create hypo-indexes;
  2. Support to use drop index to remove hypo-indexes;
  3. Show create table can show all hypo-indexes;

Describe alternatives you've considered:

Teachability, Documentation, Adoption, Migration Strategy:

PG's hypo index: https://hypopg.readthedocs.io/en/rel1_stable/

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
sig/planner SIG: Planner type/feature-request This is a feature requests on the product
Projects
None yet
1 participant