DROP_STATISTICS_PARTITION

Removes statistical data on database projections previously generated by ANALYZE_STATISTICS_PARTITION. When you drop this data, the Vertica optimizer creates query plans using table-level statistics, if available, or default statistics.

Syntax

DROP_STATISTICS_PARTITION ('[[database.]schema.]table', '[category]', 'min‑range‑value','max‑range‑value' [, 'column[,…]' )

Parameters

[database.]schema

Specifies a schema, by default public. If schema is any schema other than public, you must supply the schema name. For example:

myschema.thisDbObject

If you specify a database, it must be the current database.
table

The table on which to drop statistics.
category

The category of statistics to drop for the named table, one of the following:

  • BASE (default): Drop histograms and row counts (min/max column values, histogram).
  • HISTOGRAMS: Drop only histograms. Row count statistics remain.
  • ALL: Drop all statistics.
min‑range‑value
max‑range‑value

The minimum and maximum value of partition keys on which to drop statistics, where min‑range‑value must be ≤ max‑range‑value.

The range of keys to drop must be equal to, or a superset of, the full range of partitions previously analyzed by ANALYZE_STATISTICS_PARTITION. If the range omits any analyzed partition, DROP_STATISTICS_PARTITION drops no statistics.

column

The name of a column in table, typically a predicate column. You can specify multiple comma-delimited columns. Vertica narrows the scope of dropped statistics to the specified columns.

Privileges

Non-superuser:

  • Schema: USAGE
  • Table: One of INSERT, DELETE, or UPDATE

See Also

DROP_STATISTICS