correlated subquery

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

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 first published in September 2013

Continue Reading About correlated subquery

Glossary

'correlated subquery' is part of the:

View All Definitions

Dig deeper on Oracle DBA tools

Pro+

Features

Enjoy the benefits of Pro+ membership, learn more and join.

0 comments

Oldest 

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to:

File Extensions and File Formats

Powered by:

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide

SearchDataCenter

SearchContentManagement

SearchFinancialApplications

Close