Tuesday 12 December 2017

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

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.



from What's New (Thursday) http://ift.tt/2iVg5Hc

No comments:

Post a Comment