#database - [Unnesting Arbitrary Queries](https://cs.emis.de/LNI/Proceedings/Proceedings241/383.pdf) - [Orthogonal optimization of subqueries and aggregation](https://dl.acm.org/doi/10.1145/375663.375748) - https://zhuanlan.zhihu.com/p/589058268 - https://zhuanlan.zhihu.com/p/601449775 - https://ericfu.me/subquery-optimization/ - [The Complete Story of Joins (in HyPer)](http://btw2017.informatik.uni-stuttgart.de/slidesandpapers/F1-10-37/paper_web.pdf) - [Parameterized queries and nesting equivalences](https://www.microsoft.com/en-us/research/wp-content/uploads/2016/02/tr-2000-31.pdf) - [Optimization and Evaluation of Nested Queries and Procedures](https://arxiv.org/abs/0911.0508) - [Execution strategies for SQL subqueries](https://dl.acm.org/doi/10.1145/1247480.1247598) - [On optimizing an SQL-like nested query](https://dl.acm.org/doi/pdf/10.1145/319732.319745) - [Unnesting SQL Queries in the Presence of Disjunction](https://www.researchgate.net/publication/230867988_Unnesting_Scalar_SQL_Queries_in_the_Presence_of_Disjunction)