- 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>>);