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', '[min‑range‑value]', '[max‑range‑value]' [, category [, '[column‑list]'] )
Parameters
[database.]schema |
Specifies a schema, by default myschema.thisDbObject If you specify a database, it must be the current database. |
table | Table on which to drop 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. If you supply empty strings for both parameters, Vertica drops all partition-level statistics for this table or the specified columns. The range of keys to drop must be equal to, or a superset of, the full range of partitions previously analyzed by |
category |
The category of statistics to drop, one of the following:
|
column‑list | A comma-delimited list of columns in table, typically predicate columns. Vertica narrows the scope of dropped statistics to the specified columns. If you omit this parameter or supply an empty string, Vertica drops statistics on all columns. |
Privileges
Non-superuser:
- Schema: USAGE
- Table: One of INSERT, DELETE, or UPDATE