DROP_EXTERNAL_ROW_COUNT
Removes external table row count statistics compiled by ANALYZE_EXTERNAL_ROW_COUNT
. DROP_EXTERNAL_ROW_COUNT
runs in the background.
Statistics can be time consuming to regenerate.
Syntax
DROP_EXTERNAL_ROW_COUNT ('[[[database.]schema.]table‑name ]');
Parameters
schema |
Specifies a schema, by default myschema.thisDbObject If you specify a database, it must be the current database. |
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');