Notes: The DataBee Set Designer application does not need the source row counts in order to function. They are purely for informational use. Because the Row Count files are stored locally they will not update themselves automatically if the row counts should change in the tables in the source schema - they must be re-generated as and when required.

Please note that the Get Table Row Counts dialog box can only download the row count information for one schema at a time. To retrieve information for multiple schemas launch the Get Table Row Counts dialog box multiple times choosing a new user in the Rule Tools Tab each time.

The DataBee Get Table Row Counts Dialog Box

Shortly after the Get Table Row Counts dialog box starts, the panel at the left will fill with a list of each table known to the DataBee Set Designer. Associated with each table is one column "Src. Rows". At the immediate left of each table name is a check box. This check box indicates whether the table should be included when the row counts are requested from the remote schema.

What the columns mean

Source Rows

The Source Rows column indicates the number of rows the table contains in the source schema. If source row counts are already known, this column will be populated when the dialog box starts. Otherwise it will be populated when the row counts are taken.

Clicking on the check box to the left of the table name will cause it to be included when the row counts are requested. In order to avoid the annoyance of repeatedly clicking numerous tables, there are two buttons on the right which can select multiple tables at once. Use the Select/Unselect All Tables and Select Tables with Unknown Counts buttons to include groups of tables when the row counts are acquired.

There are two methods of acquiring row counts - either by the old fashioned SELECT count(*) from... or by picking them up out of the table statistics. The statistics method is much faster but it should only be used if it is certain that the statistics are up-to-date. Otherwise the row counts will be unavailable or erroneous. Use the Fetch Selected Table Row Count via Count(*) and Fetch Selected Table Row Count from Statistics buttons to acquire the statistics for the selected tables.

Once the table row counts have been obtained they will automatically be made visible to the Set Designer application. The row counts for the tables can also be sent to a text file in a report format using the Write Selected Row Counts to Report File button.