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