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