Updating Statistics

Scenarios

You can update database object statistics to provide the query optimizer with the latest data distribution information.

Constraints

System databases' statistics cannot be updated.

Procedure

1. Click in the upper left corner and select a region.
2. Click in the upper left corner of the page and choose Databases > Relational Database Service.
3. On the Instances page, click the instance name to go to the Overview page.
4. In the navigation pane, choose Databases and Accounts.
5. On the Databases tab page, locate the target database and choose More > Update Statistics in the Operation column.