Amazon Aurora with MySQL Compatibility Speeds Query Processing with Hash Join and Batched Scans

Posted on: Dec 11, 2017

Amazon Aurora with MySQL compatibility now supports hash joins to speed up equijoin queries. Aurora’s cost-based optimizer can automatically decide when to use hash joins; you can also force their use in a query plan. In our internal testing, use of hash joins improved the latency of queries in a decision support benchmark when using a cold buffer pool by up to 8.2x on an R3.8xlarge instance.

Batched scans are also now supported, which can speed up in-memory queries by a factor of up to 1.8x. 

These features are available in lab mode starting with Amazon Aurora MySQL version 1.16. You can read more in the best practices section of the Amazon Aurora documentation.

To learn more about Amazon Aurora, a MySQL- and PostgreSQL-compatible relational database that combines the speed and availability of high-end commercial databases with the simplicity and cost-effectiveness of open source databases, visit the Amazon Aurora product page. Please see the Aurora pricing page for regional availability.