cockroachdb / cockroachdb/cockroach
Need a quicker way to collect new statistics
- 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
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