MySQL :: MySQL 8.0 Reference Manual :: 10.2.2.2 Optimizing Subqueries with Materialization
dev.mysql.com