Updating and viewing database statistics

You can use database statistics to improve performance. You can use the workbench to update and view statistics for supported data objects.
It is useful to update statistics on data objects in the following scenarios:
Tip: Statistics information is also displayed in the Data Source Explorer as a label decorator. The table row count decorator in the Data Source Explorer displays the date at which statistics were last collected for a table, and the number of rows in the table at that time. If statistics are not found for a table for which the product supports statistics, a value of "-1" is displayed instead. For a table for which the product does not support statistics, no table row count decorator is displayed.

Feedback