-
Notifications
You must be signed in to change notification settings - Fork 4.1k
sql: control automatic statistics on a per-table basis #40989
Copy link
Copy link
Closed
Labels
A-sql-table-statsTable statistics (and their automatic refresh).Table statistics (and their automatic refresh).C-enhancementSolution expected to add code/behavior + preserve backward-compat (pg compat issues are exception)Solution expected to add code/behavior + preserve backward-compat (pg compat issues are exception)T-sql-queriesSQL Queries TeamSQL Queries Team
Description
Currently, automatic statistics are applied on a cluster level instead of a per-table basis. This can be problematic because it removes manual control of statistics for particular tables. We should consider allowing users to control automatic statistics on a per-table basis. Our defaults would still be cluster-wide as this would be an advanced tool for users to employ in conjunction with injecting statistics.
Epic: CRDB-9059
Jira issue: CRDB-5496
Reactions are currently unavailable
Metadata
Metadata
Assignees
Labels
A-sql-table-statsTable statistics (and their automatic refresh).Table statistics (and their automatic refresh).C-enhancementSolution expected to add code/behavior + preserve backward-compat (pg compat issues are exception)Solution expected to add code/behavior + preserve backward-compat (pg compat issues are exception)T-sql-queriesSQL Queries TeamSQL Queries Team
Type
Projects
Status
Done