Updating Database Statistics

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

An RDS for SQL Server instance has been connected. For details, see Connecting to a DB Instance.

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:

Parent topic: Usage of Stored Procedures

Thank you very much for your feedback. We will continue working to improve the documentation.See the reply and handling status in My Cloud VOC.

The system is busy. Please try again later.

For any further questions, feel free to contact us through the chatbot.