## Metadata * URL: [https://www.burnison.ca/notes/fun-mysql-fact-of-the-day-subquery-materialization](https://www.burnison.ca/notes/fun-mysql-fact-of-the-day-subquery-materialization) * Published Date: 2019-05-15 * Author: [[richard-burnison|Richard Burnison]] ## Highlights * materialisation strategy is the one that likely most closely aligns with your mental model of how non-correlated subqueries would work.