Alibabacloud, Database, Query Optimization, Sql, Relational Databases.
Then, assign the value of the correlated column to the subquery and compute. Finally, join the corresponding results to the original external query. If the above conversion is performed, it can be considered that the correlated column of the new input is always distinct. Now, the correlatedjoin*