Siebel Analytics Server Administration Guide > Administration Tool Basics >

Displaying and Updating Row Counts for Tables and Columns

When you request row counts, the Administration Tool retrieves the number of rows from the physical database for all or selected tables and columns (distinct values are retrieved for columns) and stores those values in the repository. The time this process takes depends upon the number of row counts retrieved.

When updating all row counts, the Updating Row Counts window appears while row counts are retrieved and stored. If you click Cancel, the retrieve process stops after the in-process table (and its columns) have been retrieved. Row counts include all tables and columns for which values were retrieved prior to the cancel operation.

Updating all row counts for a large repository will take a very long time to complete. Therefore, you sometimes might want to update only selected table and column counts. Row counts are not available for the following:

• Stored Procedure object types
• XML data sources and XML Server databases
• Data sources which do not support the CountDistinct function, such as Microsoft Access, Microsoft Excel, and multidimensional data sources

To display row counts in the Physical layer

1. Select Tools > Options.
2. In the General tab of the Options dialog box, select the option Show row count in physical view, and then click OK.

To update selected row counts

1. In the Physical layer, right-click a single table or column.

   You can select multiple objects and then right-click.

2. In the shortcut menu, select Update Rowcount.

   CAUTION:  In Online editing mode, Update Row Count will not work with connection pools set to use :USER and :PASSWORD as the user name and password. In offline mode, the Set values for variables dialog box appears so that you can populate :USER and :PASSWORD.

To update all row counts

1. Select Tools > Update All Row Counts.

   If the repository is open in online mode, the Check Out Objects window may open.

2. Click Yes to check out the objects.

   Any row counts that have changed since the last update will be refreshed.