cockroachdb / cockroachdb/cockroach

Need a quicker way to collect new statistics

Open
#121,521 0 comments 0 reactions 0 assignees View on GitHub
C-enhancement T-sql-queries
Dominant language
Go
Stars
32.5k
Forks
4.1k
PR merge metrics
PR metrics pending

Description

For large table, the create statistics/analyze takes very long time to finish. So if there was sql execution plan issue, customer has to wait for a long time.

**Is your feature request related to a problem? Please describe.**
A clear and concise description of what the problem is. Ex. I'm always frustrated when [...]

**Describe the solution you'd like**
A clear and concise description of what you want to happen.

**Describe alternatives you've considered**
A clear and concise description of any alternative solutions or features you've considered.

**Additional context**
Add any other context or screenshots about the feature request here.

Jira issue: CRDB-37302

Contributor guide

Open the contributing guide

Research direction

The issue does not name any files, tests, or entry points. Start by locating the implementation of CREATE STATISTICS or ANALYZE and the SQL execution-plan workflow, then determine what faster statistics collection should change and how its results would be validated.

Written by the indexing model from the issue text.

Assessment

Tech stack
go, sql
Domain
databases, performance
Issue type
Feature
Difficulty
5/5
Estimated time
Over a week
Activity status
Stale
Clarity
Needs clarification
Newbie friendliness
25/100

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.