Alibabacloud, Database, Query Optimization, Sql, Relational Databases.
operator allows input columns to be filtered. In addition to avoiding repeated subqueries on the same column, this method has the following advantages: New external queries always have keys since the distinct operation has been performed. The correlatedjoin* operator filters the external query