Skip to content

opt: add support for multi-column histograms #49698

@rytaft

Description

@rytaft

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

Metadata

Metadata

Assignees

No one assigned

    Labels

    A-sql-optimizerSQL logical planning and optimizations.C-enhancementSolution 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.T-sql-queriesSQL Queries Team

    Type

    No type

    Projects

    Status

    Backlog

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions