Alibabacloud, Database, Query Optimization, Sql, Relational Databases.
correlated filter (sometimes it needs to be rewritten). Then, push the correlatedjoin through filter and apply the conversion rule two. A more specific example is the tpch q17 mentioned earlier. The scalar subquery as the filter condition can also be further rewritten. The following figure shows