Detail Rows

Rows by Type and Application Database card¶

Detail Rows > Rows by Type and Application Database

This card shows the total number of rows for the selected environment/database.

Rows by Type and Application Database: Details

Element	Description
Value	This tab presents a different view than the Total Used Rows tab. IMPORTANT: All data tables are included, even those that do not determine the value of the licence.
Update frequency	The card is updated every 8 hours.
Calculation rules	For each database, the rows are grouped into: - AIH: sum of the rows of the AIH partitions, i.e. tables starting with AW_ excluding Transaction Matching tables starting with AW_TM1. - FWS: sum of the rows of the Financial Workspace tables including tables starting with DATI_ excluding tables starting with DATI_COMMENTI e DATI_NOTE. For example, the following are included: DATI_SALDI_LORDI, DATI_SALDI_IC, DATI_RETT_RIGA, etc... - ARCHIVED: sum of the rows of the archived data tables of the Financial Workspace, i.e. the tables beginning with H_DATI_. - ETL: sum of rows of ETL tables that include tables starting with MAP_. To reconcile this view with the Total Used Rows card on the Overview page, the grouped rows with the label AIH and the grouped rows with the label FWS of all databases and all environments (PROD, DEV, UAT) must be added up. The rows in the ETL and ARCHIVED groupings are shown to encourage cleaning and maintenance of the database, but do not determine the value of the licence.

# of Rows – Top 100 Tables card¶

Detail Rows> Top 100 Tables

This card shows the top hundred tables in the database, ranked by number of rows, for the selected environment/database.

Element	Description
Display values	This card has a different display than the Total used Rows card. IMPORTANT: All data tables are included, even those that do not determine the value of the licence.
Update frequency	The card is updated every 8 hours.
Calculation rules	N.A.