How Materialize and other databases optimize SQL subqueries

made by jamii, submitted by Mai
A great blog post about taking advantage of SQL's subqueries feature without sacrificing performance.