invantive documentation
Invantive Support ForumsLog In / Sign Up

RowCounts: Exact Online Row Counts

read only per partition

  • Catalog: ExactOnlineDataDictionary
  • Schema: DataDictionary
  • Label: Row Counts

Number of rows per table, as established through a fast count where possible. Tables with no fast count option are excluded.

The data in this table is partitioned per value of the Division column.

Can only retrieve data.

Performance Characteristics

Characteristic Value
Average access latency (ms) 432
Full scan rows per minute 50,300
Point query rows per minute 138

The result can be cached on the client.

Table Columns

The columns of the table RowCounts are shown below. Each column has an SQL data type. A new non-null value must be provided for every required column at all times during insert and update.

Name Data Type Label Required Marks Documentation
CATALOG_NAME varchar2 itgen_eol_catalog_name writable Name of the catalog.
COUNT int64 Count writable Number of rows found.
DIVISION varchar2 Division writable Division code.
DURATION_MS double itgen_eol_duration_ms writable Duration for retrieval (ms).
ERROR_MESSAGE_CODE varchar2 itgen_eol_error_message_code writable Code of the optional error message during retrieval of the count.
ERROR_MESSAGE_TEXT varchar2 itgen_eol_error_message_text writable Text of the optional error message during retrieval of the count.
SCHEMA_NAME varchar2 itgen_eol_schema_name writable Name of the schema.
TABLE_NAME varchar2 Table Name writable Name of the table.

Release Notes

What changed per release in the tables, columns, attributes and capabilities of the driver:

Changes of This Table, 26.0 to 27.0

  • ~ DURATION_MS (database_data_type: int64 → double)
  • ~ DURATION_MS (dotnet_data_type: int64 → double)

All changes of the driver, 26.0 to 27.0