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?
Migrate the database to a new Amazon Redshift data warehouse.
Enable hash joins on the database by setting the variable optimizer_switch to hash_join=on.
Take a snapshot of the DB cluster. Create a new DB instance by using the snapshot, and enable parallel query mode.
Add an Aurora read replica.
As I understand it, the answer is:
Enable hash joins on the database by setting the variable optimizer_switch to hash_join=on.