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 |
Database and schema. The default schema is |
| 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');