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