Skip to content

opt: Support ANALYZE with no tables to create statistics on all tables #34431

Open
Open
opt: Support ANALYZE with no tables to create statistics on all tables#34431
Labels
A-sql-optimizerSQL logical planning and optimizations.C-enhancementSolution expected to add code/behavior + preserve backward-compat (pg compat issues are exception)T-sql-queriesSQL Queries Team
@awoods187

Description

@awoods187
awoods187
opened on Jan 30, 2019

Is your feature request related to a problem? Please describe.
Currently, you must create statistics on each table in your cluster manually with something like:
CREATE STATISTICS __auto__ FROM foo1
CREATE STATISTICS __auto__ FROM foo2
CREATE STATISTICS __auto__ FROM foo3

Describe the solution you'd like
I'd like to be able to create statistics on all tables in a database or on all tables in all databases with one command or flag.

Jira issue: CRDB-4646

Metadata

Metadata

Assignees

No one assigned

    Labels

    A-sql-optimizerSQL logical planning and optimizations.C-enhancementSolution expected to add code/behavior + preserve backward-compat (pg compat issues are exception)T-sql-queriesSQL Queries Team

    Type

    No type

    Projects

    SQL Queries

    Status

    Backlog

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions