You can run and refresh the statistics for a data object in the
Data Source Explorer, and view statistics in the Properties view.
Procedure
To update and view statistics for a data object:
- In the Data Source Explorer, right-click a data object (for example,
a table or view) and select Update Statistics. If this menu option is not available, statistics are not
supported for the object and server that you selected. Statistics
are updated and the results of the RUNSTAT action is displayed in the Data
Output view.
- To view the updated statistics, highlight the object in the Database
Explorer and click the Statistics tab in the Properties
view.