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

opt: add support for multi-column histograms #49698

Open
rytaft opened this issue May 29, 2020 · 0 comments
Open

opt: add support for multi-column histograms #49698

rytaft opened this issue May 29, 2020 · 0 comments
Labels
A-sql-optimizer SQL logical planning and optimizations. C-enhancement Solution expected to add code/behavior + preserve backward-compat (pg compat issues are exception) C-performance Perf of queries or internals. Solution not expected to change functional behavior. T-sql-queries SQL Queries Team
Projects
BACKLOG, NO NEW ISSUES: SQL Optimizer

Comments

@rytaft
Copy link
Collaborator

rytaft commented May 29, 2020 •
edited by exalate-issue-sync bot

We currently only support histograms on single columns. However, it may be beneficial in some cases to collect histograms on multiple columns, especially if there is an index on multiple columns and a prefix of the columns has low cardinality (i.e., low distinct count relative to the number of rows). This issue will track the work to implement support for multi-column histograms.

Epic CRDB-16930

Jira issue: CRDB-4208

Jira issue: CRDB-13901
@rytaft rytaft added C-enhancement Solution expected to add code/behavior + preserve backward-compat (pg compat issues are exception) C-performance Perf of queries or internals. Solution not expected to change functional behavior. A-sql-optimizer SQL logical planning and optimizations. labels May 29, 2020
@RaduBerinde RaduBerinde moved this from Triage to Plan enhancements (higher priority) in BACKLOG, NO NEW ISSUES: SQL Optimizer Aug 31, 2020
@jlinder jlinder added the T-sql-queries SQL Queries Team label Jun 16, 2021
@yuzefovich yuzefovich mentioned this issue May 24, 2024
Merged
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
A-sql-optimizer SQL logical planning and optimizations. C-enhancement Solution expected to add code/behavior + preserve backward-compat (pg compat issues are exception) C-performance Perf of queries or internals. Solution not expected to change functional behavior. T-sql-queries SQL Queries Team
Projects
SQL Queries
Status: Backlog
BACKLOG, NO NEW ISSUES: SQL Optimizer
Plan enhancements (higher priority)
Milestone
No milestone
Development

No branches or pull requests
2 participants
@jlinder @rytaft