jm + joins   2

Amazon Aurora Parallel Query is Available for Preview
Looks very nifty (at least once it's GA)
Parallel Query improves the performance of large analytic queries by pushing processing down to the Aurora storage layer, spreading processing across hundreds of nodes.
With Parallel Query, you can run sophisticated analytic queries on Aurora tables with an order of magnitude performance improvement over serial query processing, in many cases. Parallel Query currently pushes down predicates used to filter tables and hash joins. 
parallel  aurora  amazon  mysql  sql  performance  joins  architecture  data-model 
19 days ago by jm
Visual Representation of SQL Joins
useful bookmark to have (via Nelson)
sql  joins  mysql  reference  database 
march 2016 by jm

Copy this bookmark: