How Do I Improve the Query Speed of My RDS Database?

The following are some suggestions provided for you to improve the database query speed:

• View the slow query logs to check if there are any slow queries, and review their performance characteristics (if any) to locate the cause. For details, see .
• View the CPU usage of your RDS DB instance to facilitate troubleshooting. For details, see .
• Create read replicas to offload read pressure on the primary DB instance.
• Increase the CPU or memory specifications for DB instances with high loads. For details, see Changing a DB Instance Class.
• Add indexes for associated fields in multi-table association queries.
• Specify a field or add a WHERE clause, which will prevent full table scanning triggered by the SELECT statement.