DROP_EXTERNAL_ROW_COUNT
Removes external table row count statistics compiled by ANALYZE_EXTERNAL_ROW_COUNT
. DROP_EXTERNAL_ROW_COUNT
runs in the background.
Caution: Statistics can be time consuming to regenerate.
Syntax
DROP_EXTERNAL_ROW_COUNT ('[ [schema.]table‑name ]');
Parameters
schema |
Specifies a schema. If multiple schemas are defined in the database, include the schema name. For example: myschema.thisDbObject |
table‑name | The external table for which to remove the exact row count. If you specify an empty string, Vertica drops the exact row count statistic for all external tables. |
Privileges
- INSERT/UPDATE/DELETE privilege on table
- USAGE privilege on schema that contains the table
Examples
Drop row count statistics for external table loader_rejects
:
=> SELECT DROP_EXTERNAL_ROW_COUNT('loader_rejects');