More intelligent setting for tidb_analyze_column_options
Open
component/statistics
sig/planner
type/enhancement
- Dominant language
- Go
- Stars
- 40.5k
- Forks
- 6.2k
- PR merge metrics
- PR metrics pending
Description
## Enhancement
Currently, its value is set to predicate, which is mainly intended for OLTP scenarios.
However, in HTAP or AP workloads, this configuration may lead to poor query plans due to missing statistics.
We need to consider how to make this parameter more visible to users or adjust it automatically.
For example:
1. Should we warn users to adjust this configuration if TiFlash replicas are detected?
2. Or automatically change the value when TiFlash is enabled?
Contributor guide
Assessment
This issue has not been assessed yet.