4 ms·
Correlated subqueries run N times, once for each outer row. Your solution (assuming the database supports predicate pushdown) is far better.
by datalopers 4y ago
Correlated subqueries run N times, once for each outer row. Your solution (assuming the database supports predicate pushdown) is far better.