You can update database statistics for a selected database table using Schema Tools.
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.
In the header of Dev Studio, click.
Select the table for which you want to update statistics.
Click Update table stats.