Count Number of Records by Table (ttaad4222m000)

Use this session to print the number of records per table for a range of companies, packages, and tables.

For each company in the range, the data is printed in one report.

Field Information

Tables Registered as Soft Delete Only

If this check box is selected, only the tables registered as Soft Delete in the Table Timestamp and Soft Delete Definitions (ttadv4136m000) session are processed.

Skip empty Tables

If this check box is selected, empty tables are omitted from the report.

Exclude Logical Tables from Count

If this check box is selected, logical tables are omitted from the report.

Detailed Report

If this check box is cleared, the session prints a report with this information:

  • The number of records per table.
  • The number of 'Soft deleted' records per table. For details on 'soft deleted' records, see Table Timestamp and Soft Delete Definitions (ttadv4136m000).
  • The size in bytes per record.
  • The size in MB per table.
  • The total size in MB of all selected tables.

If this check box is selected, additional input fields are enabled and a more detailed report, sorted on size or on table, is printed.

Sort Number of Records for Count
Specify how records are sorted on the report when you print a detailed report.
Sort by Size
If this check box is selected, the report data is sorted in descending order of size.
You can display all tables in the selection range, or only the top number of tables.
Sort by Table
If this check box is selected, the report data is sorted in ascending order of table name.
All tables in the selection range are displayed.

If this check box is selected, the report also prints the sizes of the indices per table.

This field is enabled only if you print a detailed report.

All Tables or Top
Specify how tables are shown on the report when you print a detailed report.
All Tables
If this check box is selected, the report shows the size of all tables in the selection range.
Top
If this check box is selected, the report shows the top number of tables that contain most records.
Top

Specify how many top tables (with the most records) must be shown.

For example, you specify 10. The report shows the top 10 of tables that contain most records.

This field is only enabled if the Sort by Size check box is selected.