ANALYZE_EXTERNAL_ROW_COUNT

Calculates the exact number of rows in an external table.

Calculates the exact number of rows in an external table. ANALYZE_EXTERNAL_ROW_COUNT runs in the background.

You cannot calculate row counts on external tables with DO_TM_TASK.

This is a meta-function. You must call meta-functions in a top-level SELECT statement.

Behavior type

ANALYZE_EXTERNAL_ROW_COUNT ('[[[database.]schema.]table-name ]')

[database.]schema: Database and schema. The default schema is public. If you specify a database, it must be the current database.
table-name: Specifies the name of the external table for which to calculate the exact row count. If you supply an empty string, OpenText™ Analytics Database calculates the exact number of rows for all external tables.

Any INSERT/UPDATE/DELETE privilege on the external table

Calculate the exact row count for all external tables:

=> SELECT ANALYZE_EXTERNAL_ROW_COUNT('');

Calculate the exact row count for table loader_rejects:

=> SELECT ANALYZE_EXTERNAL_ROW_COUNT('loader_rejects');