Skip to content

Support partial stats at extremes without specifying columns #127832

@Uzair5162

Description

@Uzair5162

Currently, we only support collecting partial statistics at extremes when a column is specified (eg. CREATE STATISTICS my_stat ON a FROM t USING EXTREMES). We should add support for partial stats collections without specifying a column (eg. CREATE STATISTICS my_stat FROM t USING EXTREMES).

This should collect partial stats on all appropriate columns automatically, similar to full stats collections without specified columns. We currently support partial statistics at extremes collections on single column prefixes of forward indexes.

Jira issue: CRDB-40629

Metadata

Metadata

Assignees

No one assigned

    Labels

    A-sql-table-statsTable statistics (and their automatic refresh).C-enhancementSolution expected to add code/behavior + preserve backward-compat (pg compat issues are exception)T-sql-queriesSQL Queries Team

    Type

    No type

    Projects

    Status

    Done

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions