Updating statistics

You can update database statistics for a selected table from the Schema Tools landing page. Updating internal database statistics for a table, such as the number of values in each index, enables the database to create more efficient execution plans for the queries. After initiating this operation, you can view progress and verify completion by refreshing the landing page and clicking the History tab for the table.

  1. In the header of Dev Studio, click Configure > System > Database > Schema Tools.
  2. Select the table for which you want to update statistics.
  3. Click Update table stats.