-
Notifications
You must be signed in to change notification settings - Fork 4.1k
opt: add support for multi-column histograms #49698
Copy link
Copy link
Open
Labels
A-sql-optimizerSQL logical planning and optimizations.SQL logical planning and optimizations.C-enhancementSolution expected to add code/behavior + preserve backward-compat (pg compat issues are exception)Solution expected to add code/behavior + preserve backward-compat (pg compat issues are exception)C-performancePerf of queries or internals. Solution not expected to change functional behavior.Perf of queries or internals. Solution not expected to change functional behavior.T-sql-queriesSQL Queries TeamSQL Queries Team
Description
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
Reactions are currently unavailable
Metadata
Metadata
Assignees
Labels
A-sql-optimizerSQL logical planning and optimizations.SQL logical planning and optimizations.C-enhancementSolution expected to add code/behavior + preserve backward-compat (pg compat issues are exception)Solution expected to add code/behavior + preserve backward-compat (pg compat issues are exception)C-performancePerf of queries or internals. Solution not expected to change functional behavior.Perf of queries or internals. Solution not expected to change functional behavior.T-sql-queriesSQL Queries TeamSQL Queries Team
Type
Projects
Status
Backlog