Definition

correlated subquery

A correlated subquery is a SQL query that depends on values executed by an outer query in order to complete. 

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

 

This was last updated in September 2013

Continue Reading About correlated subquery

Dig Deeper on Oracle DBA tools

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide.com

SearchDataCenter

SearchContentManagement

SearchHRSoftware

Close