Alibabacloud, Database, Query Optimization, Sql, Relational Databases.
columns, so its pushdown is simpler, which does not require the assign unique id or retain all rows. After the above conversion, correlatedjoin* can be pushed down to a place where no correlation in the left and right subtrees exists. Thus, it can be converted into an inner join based on