Bookshelf Home | Contents | Index | Search | PDF

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 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 being retrieved.

The Updating Row Counts window displays while row counts are being retrieved and stored. If you click Cancel, the retrieve process will continue for the table and its columns currently being processed, and then stop. Row counts appear for all tables and columns for which values were retrieved prior to the cancel operation.

NOTE:  Row counts are not available for the following: items that have the Stored Procedure object type; XML data sources; XML Server databases; and data sources that do not support the CountDistinct function, like Microsoft Access and Excel.

To turn on the row count feature

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

To update the row counts

Select Tools > Update All Row Counts.

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

Click Yes to check out the objects.

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

Bookshelf Home | Contents | Index | Search | PDF