A manufacturing company has an. inventory system that stores information in an Amazon Aurora MySQL DB cluster. The database tables are partitioned. The database size has grown to 3 TB. Users run one-time queries by using a SQL client. Queries that use an equijoin to join large tables are taking a long time to run. Which action will improve query performance with the LEAST operational effort?

Question

Accepted Answer

B. Enable hash joins on the database by setting the variable optimizer_switch to hash_join=on.

Answer

A. Migrate the database to a new Amazon Redshift data warehouse.

Answer

C. Take a snapshot of the DB cluster. Create a new DB instance by using the snapshot, and enable

Answer

D. Add an Aurora read replica.

A manufacturing company has an. inventory system that stores information in an Amazon Aurora MySQL DB cluster. The database tables are partitioned. The database size has grown to 3 TB. Users run…

Question

Options

How the community answered

Explanation

Topics

Community Discussion