Updating and viewing statistics for a data object

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:

  1. 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.
  2. To view the updated statistics, highlight the object in the Database Explorer and click the Statistics tab in the Properties view.

Feedback