Updating Database Statistics

You can use a stored procedure to update statistics to improve query performance.

An RDS Microsoft SQL Server DB instance has been connected.

Run the following command to update statistics on all databases by default:

EXEC rdsadmin.dbo.rds_updatestats ;

Run the following command to update statistics on a specified database:

EXEC rdsadmin.dbo.rds_updatestats '@DBname' ;

The @DBname parameter indicates the name of the database whose statistics are to be updated.

Example:

EXEC rdsadmin.dbo.rds_updatestats 'MyTestDb' ;

After the database statistics are updated, the system displays the following information: