Statistics must already be defined on at least one column of the table you select.
- 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 .
If no statistics are defined, the message “The selected table objects don't have column or index statistics and summary statistics defined” displays.
-
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>>);