Skip to content

sql: implement vectorized operator for table statistics collection #41203

Open
Open
sql: implement vectorized operator for table statistics collection#41203
Labels
A-sql-table-statsTable statistics (and their automatic refresh).A-sql-vecSQL vectorized engineC-enhancementSolution expected to add code/behavior + preserve backward-compat (pg compat issues are exception)T-sql-queriesSQL Queries Teamo-perf-efficiencyRelated to performance efficiency
@awoods187

Description

@awoods187
awoods187
opened on Sep 30, 2019

Automatic statistics (delivered in 19.1) can consume a large number of resources and take a large amount of time in certain circumstances. Using the vectorized execution framework for stats can reduce the impact of running statistics on the CBO ensuring that users continue to leave automatic statistics turned on. Without automatic stats (or manually created stats) the optimizer may make suboptimal decisions.

Epic: CRDB-747

Jira issue: CRDB-5482

Metadata

Metadata

Assignees

No one assigned

    Labels

    A-sql-table-statsTable statistics (and their automatic refresh).A-sql-vecSQL vectorized engineC-enhancementSolution expected to add code/behavior + preserve backward-compat (pg compat issues are exception)T-sql-queriesSQL Queries Teamo-perf-efficiencyRelated to performance efficiency

    Type

    No type

    Projects

    SQL Queries

    Status

    Backlog

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions