Analyze in sqlparser::ast

Analyze in sqlparser::ast - Rust

pub struct Analyze {
    pub table_name: Option<ObjectName>,
    pub partitions: Option<Vec<Expr>>,
    pub for_columns: bool,
    pub columns: Vec<Ident>,
    pub cache_metadata: bool,
    pub noscan: bool,
    pub compute_statistics: bool,
    pub has_table_keyword: bool,
}

Expand description

ANALYZE statement

Supported syntax varies by dialect:

Hive: ANALYZE TABLE t [PARTITION (...)] COMPUTE STATISTICS [NOSCAN] [FOR COLUMNS [col1, ...]] [CACHE METADATA]
PostgreSQL: ANALYZE [VERBOSE] [t [(col1, ...)]] See https://www.postgresql.org/docs/current/sql-analyze.html
General: ANALYZE [TABLE] t

Name of the table to analyze. None for bare ANALYZE.

Optional partition expressions to restrict the analysis.

§for_columns: bool

true when analyzing specific columns (Hive FOR COLUMNS syntax).

§columns: Vec<Ident>

Columns to analyze.

Whether to cache metadata before analyzing.

Whether to skip scanning the table.

Whether to compute statistics during analysis.

Whether the TABLE keyword was present.