Because a correlated subquery requires the outer query to be executed first, the correlated subquery must run once for every row in the outer query. This causes correlated subqueries to be less efficient than other subqueries.
See also: correlation
Continue Reading About correlated subquery
'correlated subquery' is part of the:
View All Definitions