- In the Navigator, double-click Databases.
-
In the Object List Viewer:
- Find the database containing the tables for which you want to collect summary statistics.
- Select one or more tables, right-click on a selected table, and select The message .Statistics are collected successfully appears.
-
To view the statistics:
- Right-click a table you selected and select Open Table.
-
Click the Statistics tab in the Table form.
Summary statistics can also be collected using the following query:
SELECT * from DBC.StatsV WHERE databasename IN (<<dbname>>) AND tablename IN (<<tablename>>);