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_ |
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_ |
double |
itgen_eol_duration_ms | writable | Duration for retrieval (ms). | |
ERROR_ |
varchar2 |
itgen_eol_error_message_code | writable | Code of the optional error message during retrieval of the count. | |
ERROR_ |
varchar2 |
itgen_eol_error_message_text | writable | Text of the optional error message during retrieval of the count. | |
SCHEMA_ |
varchar2 |
itgen_eol_schema_name | writable | Name of the schema. | |
TABLE_ |
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)