pingcap / pingcap/tidb

Predicate Columns Feature Evolution

Open
#64,992 1 comment 0 reactions 0 assignees View on GitHub
affects-8.5 sig/planner type/enhancement
Dominant language
Go
Stars
40.5k
Forks
6.2k
PR merge metrics
PR metrics pending

Description

## Enhancement
1. Temporarily change the default value to "all" and cherry-pick it back to 8.5. And we ensure no analyze performance regression during upgrades, if users were previously using "predicate," they will continue using "predicate" after the upgrade.
2. Make more efficient and lower-cost collection of all NDVs the evolution goal for the next phase. Once this feature is delivered, collect NDV for all non-predicate columns, but don't collect TopN and Buckets.
3. For SaaS scenarios, explore how to enable new tenants to inherit predicate columns.
4. Once steps 1, 2, and 3 above are all completed, change the default value back to "predicate."

Contributor guide

Open the contributing guide

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.